Introduction
  • Introduction to VBA
Recording a Macro
  • Getting started
  • Recording first Macro
Objects in VBA
  • Overview
  • Object under project
  • Worksheet object
  • Rows and columns
  • Cell object
  • Range object
  • Properties and range
  • Properties and method
  • Dates
  • Working with color
  • Variables
Various boxes and functions in VBA
  • Message box
  • Input box
  • Button
  • If then
  • With .. end with
  • Case
  • For
  • Do loop
  • Logical operator
  • User defined functions
  • Event handling
  • Copy and paste
  • Conventions
  • Array
  • Importing data
  • Calculator
  • CountA function
  • For each loop
  • Password protection
Userforms
  • Userform
  • Forms and label
  • Creating a userform
More features
  • Text box
  • List box
  • Combobox
  • Checkbox
  • Option button
  • Command button
  • Multipage
  • Image
  • Export and Import
Conclusion
  • Conclusion
All Exercise files
  • Exercise files