form appears on second monitor
Paul,
Look at the .StartUpPosition property of the userform.
May depend also how you have you video display/driver set up.
If you second monitor (physically, left to right) is actually number 1, that
may make sense.
Trying relocating the monitors or switching the numbers to match the left to
right order.
NickHK
"Paul Pedersen" wrote in message
...
In VBA, I have a simple statement to display a form when a certain
worksheet
is selected:
Private Sub Worksheet_Activate()
frmMyform.Show
End Sub
But when the form appears, it always appears on the second monitor. It
doesn't matter which monitor is showing the worksheet. Furthermore, even
though both form.top and form.left are zero, the form appears up against
the
left edge of the monitor as expected (although the wrong monitor), but
centered vertically.
How can I put the form where I want it?
|