Recall & Review
beginner
What is a UserForm in Excel VBA?
A UserForm is a custom dialog box that you create in Excel VBA to collect user input or display information in a friendly way.
Click to reveal answer
beginner
How do you add a UserForm in Excel VBA?
In the VBA editor, right-click on any item in the Project Explorer, choose Insert, then select UserForm.
Click to reveal answer
beginner
Name two common controls you can add to a UserForm.
You can add controls like TextBox (for typing input) and CommandButton (for clicking actions).
Click to reveal answer
beginner
How do you show a UserForm to the user?
Use the VBA code line UserFormName.Show to display the UserForm on the screen.
Click to reveal answer
beginner
What happens when you click a CommandButton on a UserForm?
Clicking a CommandButton runs the VBA code written in its Click event, allowing you to respond to user actions.
Click to reveal answer
How do you open the VBA editor in Excel?
✗ Incorrect
Pressing Alt + F11 opens the VBA editor where you can create UserForms.
Which control lets users type text in a UserForm?
✗ Incorrect
TextBox is used to get text input from users.
What VBA code shows a UserForm named 'MyForm'?
✗ Incorrect
The correct syntax to show a UserForm is 'UserFormName.Show'.
Where do you write code for a UserForm's button click?
✗ Incorrect
You write code inside the button's Click event to respond to clicks.
Which of these is NOT a UserForm control?
✗ Incorrect
PivotTable is an Excel feature, not a UserForm control.
Explain how to create and show a simple UserForm with a button in Excel VBA.
Think about the steps from opening VBA to showing the form.
You got /5 concepts.
Describe the purpose of UserForms and how they improve user interaction in Excel.
Consider why you would use a UserForm instead of just cells.
You got /5 concepts.