positioning msgbox and userforms

[Guest]

hi all,

I have a worksheet that uses/needs 2 monitors to view it. When msgboxes pop-up they are always positions bang in the middle of the worksheet so are therefore split between one screen and the other. Same with user forms - but with the StartUpPosition option I can get it to be in the middle or in the very top right hand corner - neither or which are very useful. Any idea how I can get msgboxes and userforms to sit nicely in the centre of my left hand monitor screen automatically?

Many thanks in advance.

 

[Bob Phillips]

Brownie,

Take a look at http://www.cpearson.com/excel/FormPosition.htm.

Not sure if it works with dual monitors, but you could try it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

hi all,

I have a worksheet that uses/needs 2 monitors to view it. When msgboxes

pop-up they are always positions bang in the middle of the worksheet so are
therefore split between one screen and the other. Same with user forms -
but with the StartUpPosition option I can get it to be in the middle or in
the very top right hand corner - neither or which are very useful. Any idea
how I can get msgboxes and userforms to sit nicely in the centre of my left
hand monitor screen automatically?

 

[Chip Pearson]

Not sure if it works with dual monitors, but you could try it.

Yes, it works on multiple monitor setups.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

Thanks Chip for that.

Bob

Yes, it works on multiple monitor setups.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com