I don't delve into VBA very often and have only just discovered this forum so what follows may reveal that I'm a bit rusty. Please bear with me.
My system has two monitors. When I bring up Excel with the window maximized it will always come up on the monitor that it was last on. One of my spreadsheets runs a macro that displays a UserForm. I want this form to appear on the spreadsheet, i.e. on whichever monitor that displays the spreadsheet. However the UserForm always appears on the primary monitor, never the secondary monitor even if the spreadsheet comes up there. I can't find any way to detect which monitor that the spreadsheet is on or reposition the Userform to the desired monitor. The Left property only positions it on the primary monitor.
Can anyone provide some information on how to deal with these issues, both the UserForm position matter and how Excel and/or Windows knows which monitor to use? I'm running 98SE and Excel 2000 if that matters.