Excel Macros & VBA
Course Duration: One Day
Target Audience:
Aimed at experienced Excel users who want to automate repetitive tasks in Excel. This course is suitable for participants who are responsible for building interactive spreadsheets for other users.
Course Objectives:
On this course, learners will create macros for repetitive tasks in Excel, use VBA to automate spreadsheets using program control statements, iterative loops, dialog boxes, custom forms, and some basic programming techniques.
Course Outline:
Course Introduction
Overview of the Excel Macro Facility
-
When to Use Macros
-
The Efficient Storage of Macros
-
Displaying the Developer Tab in Excel
-
Saving as a Macro Enabled Workbook
Recording a Macro
-
Keystroke Macros
-
Absolute and Relative Recording Facilities
Assigning Macros
-
Assigning Macros to a Button or Picture
-
Assigning Macros to the Quick Access Toolbar
Viewing Recorded Macros
Using the Visual Basic Editor
-
Code Window
-
Project Explorer
-
Properties Window
-
Importing and Exporting Modules
VBA Language
-
Objects, Methods, Properties
-
Declaring Variables
-
Using Variables
-
Using Message Boxes and Input Boxes
-
Using Program Control Statements
-
Building and Using Iterative Loops
Custom Forms
-
Textboxes and Labels
-
Command Buttons and Radio Buttons
-
Check Boxes and Combo Boxes
Debugging
-
Compiling a Macro
-
Stepping Through the Macro
-
Inserting Breakpoints
-
Adding and Managing a Watch Window
Automatic Procedures
-
On Opening a File
-
On Closing a File