Microsoft Excel Training – Introduction to Macros

Testimonials

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