To add a UserForm, we need to do the same thing when we add a new module:
After that, a form (UserForm) and a toolbar (Toolbox) will appear:
If you don't see the Properties window (Properties), make sure it is displayed and then start editing the Form name > (so you can easily find it later):
A
Form (UserForm) has its own events, just like a workbook or sheet does. To add an event, double-click on the Form (UserForm).
Now let's create two events to see how this works. The first event will determine the initial size of the Form, and the second event will increase its size by 50px when the user clicks.
The UserForm_Initialize event will fire when the Form is launched:
Private Sub UserForm_Initialize()
my_userform.Height = 100
my_userform.Width = 100
End Sub
To simplify the code, we can use Me instead of the Form name (because this code is in the Form we are working with):
Private Sub UserForm_Initialize()
Me.Height = 100
Me.Width = 100
End Sub
The second event will occur when the user clicks on the Form:
Private Sub UserForm_Initialize()
Me.Height = 100
Me.Width = 100
End Sub
Private Sub UserForm_Click()
Me.Height = Me.Height + 50
Me.Width = Me.Width + 50
End Sub
To run a Form in a procedure, use a Show method:
Sub show_userform()
my_userform.Show
End Sub