Centering A Userform On The Sheet

J

John Calder

Hi

I run Excel 2K

I have a userfrom that is used for data input. When the form loads onto the
worksheet it is always at the left of the screen. I would like the userform
to open in the centre of the worksheet. Can anyone tell me how this can be
achieved?

Thanks

John
 
S

Shane Devenshire

Hi,

The userform opens in the center of the screen by default, so if it is not
doing that you have changed something.

Try selecting the user form in the VBE and checking the StartUpPostion
property - it should be set to 2 - CenterScreen
 
J

John Calder

Shane

You were absolutely correct !

The form was set to manual. Once I set it to 2, all was fixed

Well Done !


John
 
Top