Resize Event
Occurs when a user form is resized.
Syntax
Private Sub UserForm_Resize()
Remarks
Use a Resize event procedure to move or resize controls when the parent UserForm is resized. You can also use this event procedure to recalculate variables or properties.