Fixing Excel’s Dual Monitor Problem
I posted a tip that solves an annoying problem: Dual Monitors and UserForms.
One of the things I'll be doing in PUP v7.1 is to add this fix to all of the UserForms.
- Reader Comments -
Following are comments in response to this item.
The most recent comment is at the bottom.
- By Omar. Comment posted 10 January, 2010 1:54pmIt's not just a problem with user forms. I see this behaviour with various built-in dialog boxes. Some boxes are consistent, but others seem to have some random generator choosing their position. It's kind of like a game of whack-a-mole to guess where the box will be.
- By Miro. Comment posted 10 January, 2010 9:39pmOn my system, it seems to happen only under very specific circumstances:
- UserForm starts on the secondary monitor; and
- secondary monitor extends the desktop to the right; and
- UserForm_Initialize() changes the .Width and/or .Height properties.
However it still works fine:
- on the primary monitor; or
- on the secondary monitor extending desktop to the left; or
- if I leave .Width / .Height properties untouched.
- By John Walkenbach. Comment posted 11 January, 2010 8:46amSo maybe it's a display driver problem rather than an Excel problem. I just updated my drivers, and it had no effect. UserForms always appear on the left edge of my secondary monitor, centered vertically -- unless the VB Editor window was last used on the primary monitor. In that case, the UserForm appears on the right edge of the primary monitor.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.