Using Two Monitors

A

Al

I am using two monitors and have this question.

Is there any way to control a UserForm such that it will always pop up on
the screen of my choice?

For example, I want the UserForm to always opn on the right hand monitor but
it pops up on the left one, even though the Excel file is on the right hand
monitor.

Thanks
Al
 
K

K Dales

Dual monitor support is not native to Excel or VBA. I am pretty sure you
could do this, but think it would require some advanced programming tricks.
The solution is to be found either in the Windows API or your video card's
display driver - or, probably, a combination of these two.
 
A

Al

Thank-you

We did discover that the UserForm was using a Manual StartUpPosition and
that was causing the UserForm to NOT follow Excel
We changed it to CenterOwner and now it makes the form open up on the same
side as Excel

That's a little better than before

Thanks again for taking the time to respond.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Multiple Monitors with Excel Spreadsheet with VBA Code 1
Two Monitors 1
Form Display 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Form, Dual Monitors 1
ASK Field Formatting 1
Viewing with dual monitors 2
form appears on second monitor 2

Top