Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form appears on second monitor
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form appears on second monitor
I found the startupposition property, thanks.
That second monitor actually is #2. But the problem seems to have gone away when I set startupposition to Center. "NickHK" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Monitor ? | Excel Discussion (Misc queries) | |||
message box appears and appears | Excel Discussion (Misc queries) | |||
clipboard monitor | Excel Programming | |||
monitor clipboard | Excel Discussion (Misc queries) | |||
Monitor Changes | Excel Programming |