Most of the people in my office have a dual monitor setup.
I have an Excel VBA macro that shows sorted quotes, orders, etc. One of the Sheets has a command button that brings up a userform, however the form shows up on the opposite monitor from the one being worked on more often than not.
Is anyone familiar with a technique to define which monitor the userform with display on? Or that the userform shows up on the same screen as the active sheet?
Thanks much!
I have an Excel VBA macro that shows sorted quotes, orders, etc. One of the Sheets has a command button that brings up a userform, however the form shows up on the opposite monitor from the one being worked on more often than not.
Is anyone familiar with a technique to define which monitor the userform with display on? Or that the userform shows up on the same screen as the active sheet?
Thanks much!