positioning msgbox and userforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Brownie said:
hi all,

I have a worksheet that uses/needs 2 monitors to view it. When msgboxes
Click to expand...
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?
 
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
 
Back
Top