Tabellab
Menu
Courses Guides Pricing Log in Start free
Intermediate

UserForms

Build proper data-entry windows so people stop typing straight into your spreadsheet.

7 lessons 58 min Certificate

Start the course Unlock all courses

The first lesson is free — no account needed.

About this course

Build proper data-entry windows so people stop typing straight into your spreadsheet. You create a VBA UserForm, tour its controls, fill a ComboBox and ListBox in the Initialize event, use CheckBoxes and OptionButtons, validate what people type, and write the results to a sheet.

Lessons

  1. Your First UserFormReading12 minFree
  2. A Tour of the ControlsReading8 min Pro
  3. The Initialize EventReading7 min Pro
  4. ComboBox and ListBoxReading8 min Pro
  5. CheckBoxes and OptionButtonsReading7 min Pro
  6. Validating What People TypeReading8 min Pro
  7. Writing Results to a Sheet and ClosingReading8 min Pro