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
 

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

save user inputs from userform in a seperate workbook 6
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Worksheet appears briefly before UserForm opens 4
HELP: update access from excel userform 2
populate dropdown/combobox on userform with specific values from s 3
Userform with 1024+ textboxes 13
Userform on two monitors 0
show a userform and still work on the below worskheet? 3

Back
Top