Microsoft Excel Training – Introduction to Macros



Excel

1. Understanding & Working with Macros

  • What is a macro?
  • Planning a macro
  • Setting the Macro security level
  • Saving & opening a workbook containing a macro
  • Recording & saving a new macro
  • Working with the Trust Center
  • Running macros
  • Inserting command buttons & assigning macros
  • Inserting a graphic & assigning a macro
  • Making a button visible on printouts
  • Recording a macro & assigning it to multiple buttons
  • Adding macro buttons to the Ribbon or Quick Access toolbar
  • Running a Macro when opening workbook to update data

2. Modifying a Macro

  • Opening the Visual Basic Editor
  • Displaying the Project Explorer windows
  • Displaying & inserting modules
  • Editing macros using the Visual Basic Editor
  • Renaming or deleting macros
  • Getting data with the InputBox function
  • Writing an If-Then-Else selection structure
  • Writing an interaction structure
  • Writing a custom function
  • Printing VBA codes
  • Writing Subroutines

3. Inserting Form Controls & Active X Controls

  • Adding Form Controls
  •   – Adding Buttons
  •   – Adding Check boxes & Text Fields
  •   – Adding Spin buttons * Scroll bars
  •   – Adding Option buttons & Group boxes
  •   – Adding List boxes and Combo boxes
  • Adding Active X Controls
  •   – Adding Command buttons
  •   – Writing a code for a Command button
  •   – Adding Text boxes
  •   – Adding Spin buttons & Scroll bars
  •   – Adding Check boxes & Option buttons
  •   – Adding List boxes & Combo boxes
  • Setting Control properties