UserForms are custom dialog boxes with labels, text boxes, dropdowns, checkboxes, and buttons. They are the way to collect several inputs at once or to build a small app inside Excel.

Code

UserForm1.Show

• Show a form

  Insert > UserForm, add a ComboBox and a CommandButton, then UserForm1.Show → The dialog appears

  Design in the editor, show from code.

• Handle a button

  Private Sub CommandButton1_Click() Range("B1").Value = ComboBox1.Value Unload Me End Sub → Writes the selection to the sheet and closes

  Button code lives in the form module.

• Populate on open

  Private Sub UserForm_Initialize() ComboBox1.List = Array("West", "East") End Sub → Fills the dropdown when the form opens

  Initialize is the form's setup event.

• Show vbModeless to let the user work while the form is open.
• Use Me inside the form module to refer to the form.
• Tab order is set in the form's properties.

• Forms do not scale well on high-DPI screens.
• Unload versus Hide: Hide keeps the values, Unload resets them.