Centering a Userform after Height Change

C

Craig

I have a userform that is centered on the screen when first opened. When I
click a commandbutton on the userform it changes the height of the form...
How do I make the userform re-center itself again?

Thanks Again
Craig
 
G

Guest

Hi Craig,

Maybe not the most clean option but after the change of the height of the
form insert:
Me.Hide
Me.show

It will sort of refresh the form and center it again

Regards,

Erik Kuipers
 

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

Centralizing a command button on a userform 8
Position Userform In Cells Portion of Excel Only 1
Hiding a "Userform" instead of closing it??? 3
change the appearnce of a userform 2
IS it possible to add Hyperlink to a commandbutton on a Userform 9
How to enumerate buttons on user form 2
Auto-size the UserForm with Monitor Configuration 3
Worksheet appears briefly before UserForm opens 4

Top