Re: UserForm displayed on second monitor

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Howard Kaikow (kaikow_at_standards.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 18:15:42 -0500

Where a Userform is displayed depends on the handle of the Parent of the
Userform.
I've always seen Userforms associated with the main Word window, but then
I've never used dual monitors.

Perhaps you need to set the Parent of the Userform when using two monitors? 

-- 
http://www.standards.com/; See Howard Kaikow's web site.
"J Whales (anti-spam alias)" <jwhales@gmail.com> wrote in message
news:1111178472.831888.212710@o13g2000cwo.googlegroups.com...
> Hello!
>
> I have a somewhat annoying problem...  I work with two monitors, with
> Word or Excel on one side and the VBA IDE on the other.
>
> When I display a userform, it shows up on the monitor where the IDE is
> located (whether or not the IDE is actually openned) instead of in the
> middle of the monitor where Word or Excel is openned.
>
> Is there some settings that would prevent that?
>
> Thanks for your help
>
> J Whales
> (anti-spam alias)
>

Relevant Pages

  • Re: Pull Recipient from Outlook Address book
    ... When you describe the scenario and state "(should then be in the textbox to ... I set up the following sub for the UserForm Activate event. ... What I'm trying to do, is thru an excel userform, open up the outlook ... The Outlook Display Name is the name that recipients see in emails. ...
    (microsoft.public.excel.programming)
  • Object creation
    ... I thought that I could easily copy a single Excel file from ... I've built my userform and got some of the code running. ... display the link names accordingly. ... range of 3 columns and then show that in my control. ...
    (microsoft.public.excel.programming)
  • Re: Dynamic UserForm and VBE
    ... || userform with dynamically rendered controls and dynamically output VBA ... I notice that when I display ... || doc to be displayed behind the form instead of the VBE!). ... || Public Sub ShowForm() ...
    (microsoft.public.word.vba.userforms)
  • Dynamic UserForm and VBE
    ... Userform newbie here...looking for some help. ... doc to be displayed behind the form instead of the VBE!). ... display other, static userforms there is nary a VBE window to be seen. ... Public Sub RunFoo() ...
    (microsoft.public.word.vba.userforms)
  • Re: ....SPOT THE USERFORM!!!!.....
    ... I'm one of the lucky ones with 2 monitors and it just plonks the form ... "CenterScreen", could well split your userform over the 2 screens, so you ... Private Sub UserForm_Initialize ... The called routine, "SelectDataRow", is the following: ...
    (microsoft.public.excel.programming)