Userform opens on different screen than Excel Program

[randell.graybill]

I want to have both the Excel User form and Excel Program open on the same screen. The user may have the excel program on either the primary or secondary monitors and I don't want to have to ask the users to use the program on one specific screen. I have found code to change where the position of the form opens but this isn't useful if I can't also find the coordinates of the active Excel Program.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[davesexcel]

This is the code I use for dual monitors

http://spreadsheetpage.com/index.php/tip/C29

[randell.graybill]

That worked!