Dual Monitors and exact Userform position in the Active window

Hello All,

I have explored threads about the Dual Monitor and UserForm position recently. Many solutions have been offered, some work, some don't. As well, most solutions deal with a Userform 'centered' in the screen. My intent is that the end-user would be using only 1 monitor for the Excel Active Window and UserForm even if they may have a Dual Monitor set-up. My goal is to have a solution that allows the UserForm to be located in the lower-left side (or any other chosen position) of the Excel Active Window monitor, in Full Screen Mode, so I can design the sheet pages around this position placement. Confidence in the ultimate UserForm position for the end-users is paramount.

I am new to VBA but am surprised that the solutions to this subject are so mercurial. Any help would be most appreciated! I apologize in advance if I have overlooked possibly posted solutions.

55horses.

.....

Originally Posted by AlvaroSiza

This is strictly a thought (so make a test copy before you try anything), but what happens when you set the properties within the _activate event like:

Please Login or Register  to view this content.

Thanks for replying. Adding the above bit of code throws the UserForm onto the second monitor. It is left and low, but travels off of the page in both respects.

All,

that last selection did the job. The only limitation being that it is center-screened and I can't seem to get around to forcing it to a particular position. For now, I can live with this. I don't want to get too hung up on this part or the whole project will lag.

thanks very much.

Please Login or Register  to view this content.

Sorry for bumping an old thread, but the solution suggested simply doesn't work for me... although basic maths suggests it should, everything looks okay but on Excel 2k10 this doesn't center properly on any screen which the application is on. The .Top seems to be okay, but the .Left is way too much to the left. If I try to debug it... I just set .Left = Application.Left, so the left side of the userform should intersect which the left edge of the window, on the primary monitor it intersects perfectly, on the secondary monitor the userform actually is quite a bit way left of the left edge of the window when I do this, when I manually move the userform to the edge of the window it's clear that Application.Left isn't being reported correctly for an Excel instance on the secondary monitor. The Application.Width properties also seems to be a little too large for both monitors which means that the the overall .Left is increased, put all this together and it doesn't center properly.

What I'm getting from this is the Application.Width and Application.Left properties aren't being reported corrrectly. I've tried this on multiple Excel 2010 systems, is there an alternative to this method? It should work but it doesn't on my systems..

Many thanks.

Hello RedWing.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

for position the userform. Is possible to start at the bottom of the monitor going up?