2 User Forms 2 different screens 1 computer

[loplop]

I have been able to get 2 userforms on 2 different screens, BUT when you click the one on the left it jumps over to the right screen.
code.PNG
Capturew.PNG
Here is the code for the submit buttons. They are exactly the same on both

Please Login or Register  to view this content.

[LJMetzger]

Hi,

I don't see anything in your code that causes the UserForm to switch screens. That would generally be caused by

Please Login or Register  to view this content.

See the attached file that demos switching Excel and/or UserForms between screens.

Some of the code is included below. Please note that I am not good enough to automatically detect whether the Left or Right Monitor is the Primary Monitor. I use the 'Right Monitor' as Primary. If you use the 'Left Monitor' as Primary, you have the change the item in red below to 'LEFT' at the top of Ordinary Code Module ModTwoMonitors.

Please Login or Register  to view this content.

Lewis