Centering A Userform On The Sheet

  • Thread starter Thread starter John Calder
  • Start date Start date
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
 
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
 
Shane

You were absolutely correct !

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

Well Done !


John
 
Back
Top