Shane

You were absolutely correct !

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

Well Done !


John


"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"John Calder" wrote:

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