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" wrote in message
...
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.

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" wrote in
message ...
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" wrote in
message
...
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.

Thanks Chip for that.

Bob

"Chip Pearson" wrote in message
...
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" wrote in
message ...
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" wrote in
message
...
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.