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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
I figured out the issue thank you. 0
Menu driven PowerPoint presentations 0
Worksheet appears briefly before UserForm opens 4
Creating a Search using a combo box and then creating a report. 4
Sorting rows 16
Create a dynamic list on a userform outside of a list control 0
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top