Help with Dual Monitors

[loplop]

I have a computer running dual monitors. I can open 2 excel files, but when I run the Userform from one of them, all other Excel files disappear. Is there a way to run 2 different forms on 2 different monitors?

[MarvinP]

Hi loplop,

Userforms have a property of "Show Modal", which if true can only show a single userform at a time. See what happens if you set that property to False. I'm not sure if you can work in both open userforms but that is what I'd be trying.

[loplop]

I can now get them on both screens, but when I hit submit on the form on the left screen, it jumps over to the right screen?

[MarvinP]

Hi loplop

I have dual monitors. One is my Surface Book 2 and two is a big 4k monitor. With each release of Windows 10 beta there would be some new problem or concern. Dual monitors is much better with some of the newer releases of Windows 10 beta.
I have one problem I've never resolved. Using the VBA code window, if I use it on the extended monitor the drag sidebars don't work, but if I drag that same window down to my Surface (number 1) screen they do. I think VBA never thought of people having or needing dual monitors. I don't know of a VBA command that will allow you to place the userform where you want it. If there were and you put it on the second screen, what would happen with a person with only a single screen?