Microsoft Excel Introduction to Macros and VBA

Contact us for dates, pricing and how we can customise courses to your requirements: contact us

Microsoft Excel Macros and VBA

Duration: 1 day

  • Introduction to macros
  • Recording macros
  • Running macros
  • Assigning specific workbook/worksheet macros to keystrokes
  • Assigning specific workbook/worksheet macros to objects on the workbook/worksheet
  • Assigning global macros to toolbar buttons
  • Assigning global macros to menus
  • Deleting macros
Visual Basic Editor
  • Introduction to the Visual Basic Editor
  • Understanding Projects, Modules and User Forms
  • Writing modules that include message boxes and input boxes
  • Creating user forms
  • Using the toolbox to add controls to the user form
  • Understanding simple visual basic code
  • Writing VB code behind controls
  • Understanding variables
  • Declaring and using variables