ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Centering a Userform after Height Change (https://www.excelbanter.com/excel-programming/349025-centering-userform-after-height-change.html)

Craig[_21_]

Centering a Userform after Height Change
 
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



Erik[_7_]

Centering a Userform after Height Change
 
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

"Craig" wrote:

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





All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com