J-Walk & Associates, Inc.

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.

1. By Omar. Comment posted 10 January, 2010 1:54pm

   It'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.
2. By Miro. Comment posted 10 January, 2010 9:39pm

   On 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.
3. By John Walkenbach. Comment posted 11 January, 2010 8:46am

   So 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.