I'm sure this has been asked before, but I can't seem to find any posts that address it. A user has a dual monitor system and always opens Excel files on his SECONDARY monitor. When the Excel sheet has macros that display a modeless userform, the form always appear on the PRIMARY monitor, not the monitor displaying the Excel worksheet.

How does one ensure the userform appears on the same monitor as the Excel worksheet?

Through my searches I've seen several references to setting userform.StartUpPosition = 0 and adjusting userform.Left and userform.Top based the values of Application.Width and Application.Height, but that doesn't change the behavior at all in the above scenario.