Center Userform

[Molden]

Hi,

I have some code that extends my userform depending on what is selected on a drop down box. But when I shrink the userform it is no longer in the center of the screen.

Does anyone no how to center a userform via code.

Thanks

 

[Evagrius Ponticus]

Hi,

In the properties box, under the position title, check the "center screen" option - see if that works. You can also try

UserForm2.StartUpPosition = 2

 

[Andrew Poulsom]

As a user I would find it very disconcerting if a UserForm moved on the screen when it was resized. In my view you should stick with the initial left and top positions, allowing for any increases in size.

 

[Molden]

it just looks a bit weird - one minute its in the center and next its more to the left.

Thanks for the advise though I will try the above code first.