Using Multiple Monitors with Excel Spreadsheet with VBA Code

[Connie]

I have a user who is using two monitors at his workstation. When he runs my spreadsheet, the spreadsheet appears on one monitor and all message boxes, user forms, etc. appear in the 2nd monitor. Is there any way to have themessage boxes and user forms appear in the same monitor as the spreadsheetas it would if you only had one monitor? Thanks!

Connie

 

[Dave Unger]

Connie,

Have a look at this link to John Walkenbach's site:

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

regards,

Dave