Making Userforms appear in the middle of the primary screen

**tenk283** · 09-14-2010, 12:06 AM

I work over two screens, one is via the usual monitor port, the other is through a HDMI cable.

When I activate a userform, it pops up against the side of the secondary screen, not in the middle of the primary screen.

Is there any way to set the location that the userform pops up to?

Is it possible to set that location to be in the middle of the screen that the excel spreadsheet is open on?

thanks in advance... i don't have the fuzziest idea where to start on this one.

**MarvinP** · 09-14-2010, 12:30 AM

In the Userform Properties (on the Categorized Tab) under Position:
Change the Top, Left or StartUpPosition.

**romperstomper** · 09-14-2010, 02:58 AM

It's not something I've done, but I suspect you might need APIs to set the main excel window as the parent of the userform (IIRC, the desktop is normally the parent).

**tenk283** · 09-15-2010, 12:01 AM

In the Userform Properties (on the Categorized Tab) under Position:
Change the Top, Left or StartUpPosition.

Changing the startup position didn't do anything. "Centre Owner" and "Centre Screen" still plonked the userform on the lefthand edge of the right hand screen.

Changing the startup position to "windows default" made the userform appear at the top left hand corner of the lefthand screen... Which is the main screen.

Using the manual setting, i've managed to set it to the middle(ish) of the second screen... Will this setting change if different users have different sized screens? Will this screw things right up if the user has only one screen?

**Launchnet** · 09-15-2010, 12:40 AM

I have used 2 monitors for years.

I don't know why or if you have a need to use the HDMI cable. I use one monitor from the motherboard and the other from a standard monitor display card. I can have anything come up on either monitor and in the same position each time. If I drag an excel workbook to the other monitor, it will be there the next time that it is opened.

Both monitors are the same size, but different mfg's. I believe that all the settings of each monitor remain as is and can be changed independently.

This may give you some ideas ?

**tenk283** · 09-15-2010, 02:00 AM

The reason I use a HDMI cable is i'm running two monitors off a laptop computer. So I've got one connected normally, then another via hdmi.

both my screens are exactly the same.

I'm thinking its just my machine... I've got the same macro implemented over several machines. Nobody else has this problem. All their userforms pop up dead smack bang in the middle of their workbook, every time. Even one of the guys that has three screens, it still works perfectly.

I'll post back if i manage to sort it out.

**tenk283** · 09-15-2010, 02:03 AM

Fixed it...

By switching the main screen. Go figure.

If there is some guru out there with a reason this happens, i'm all ears. But for the moment: you can fix it by changing your main screen.

**AKK9** · 09-15-2010, 04:09 AM

This doesn't help much, but I also have the issue. I haven't looked into it much but I'll experiment with it this evening and post some info if it helps.

I'm also running a second screen from a laptop. I only have my laptop screen, and then the monitor conencted via HDMI. It could be something related to Mobile GPU's or maybe the HDMI cable but I wouldn't think a cable could have much effect on that sort of thing.

What graphics card do you have?

**tenk283** · 09-15-2010, 10:26 PM

Originally Posted by tenk283

Fixed it...

By switching the main screen.

Graphics card isn't anything special. And i don't think the cable would screw with window (as in application window) position.

But i managed to fix it. Try switching your main screen from wherever it is to wherever its not (if you catch my meaning).

It seems windows is interferring with Excel's screen position.

**AKK9** · 09-16-2010, 04:13 AM

It's hard to say how a graphics card and/or it's drivers can actually affect your system. I think you'd be surprised what sort of problems can come with just a new driver on it's own.

Anyway, it's a little different on my laptop:

If I close Excel on my secondary monitor and then re-open (it reopens in the same position I closed it) my boxes appear in some retarded place no matter where I move the window. However, if I close Excel and open it on my primary monitor the dilog boxes appear in the centre of the Excel window, even after I move it or maximise it to my secondary monitor.

Not sure if this helps or not but if it works for you it could be a better solution than having to change your primary monitor every time.