Userform position

[cedricthecat]

(didn't there used to be a section for "Technical Problems"? I'm guessing this is one of those rather than a programming issue....)

Anyway!

Hi folks

Using a dual monitor set up at work, I'm finding that my userforms are popping up to the far right of the smaller monitor (mounted to the right of the principle screen). This is annoying as it means a good few inches of mouse movement to click a box that is appearing about 2 feet to the right of where it should be!

I can put the whole Excel application onto the smaller screen, but as the latter is not widescreen (which the principle one is) then I'm losing information off the edge of the display

The same workbooks work fine at home (single display laptop) so I;m just wondering if there's anything I can do to "tie" the userform to where Excel is being run?

 

[VoG]

Hi Dave. Maybe this will help http://www.mrexcel.com/forum/showthread.php?t=530636

 

[Richard Schollar]

Hi Dave

You can manually set the position the userform opens in by adjusting the StartUpPosition property to 0 (manual) and then specifying Left and Top properties with a value.

 

[cedricthecat]

Thanks both

Just looked and I have the StartUpPosition property to 0 already, with defined top and left properties

The problem I have is, I guess, two-fold

1. I need to have the forms set up for both my (work) dual screen set up and my (home) laptop set up - and thus defining for one will mess up the other!
2. The issue at work doesn't seem to be constant (sometimes the Userform is miles away, sometimes it appears just where I want it!)

On top of this, it's affecting Userforms across a whole range of Workbooks

I think it might be more of a Windows problem?

 

[cedricthecat]

As an update to this, in case anyone else is suffering the same, I now have a solution!

It appears that it was all down to where I have the VBA Project Window. If it's on the second monitor, all userforms appear on there, but if it's on the main monitor, they appear where they should!

Sorted!