Microsoft Excel - Macros
Course Description
This is a Microsoft Excel Macros course. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions and can be run whenever you need to perform the task. The course introduces delegates to the whole area of macros. The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.
Course Duration
1 day
Course Objectives
On completion candidates should have progressed their skills to produce and edit interactive Microsoft Excel Macros, create and customise the Excel menu and toolbar options, and understand VBA Modules.
Course Content
RECORDING MACROS
Recording a relative macro
Recording an absolute macro
Creating a Quick Access Toolbar button
Stepping through macro created code
EXPLORING THE VISUAL BASIC EDITOR
Turn On/Off the Explorer
Turn On/Off the Properties Window
The Immediate Window
WORKING WITH MODULES
About Modules
Moving Around the Module
EDITING A MACRO
Editing a Macro
Adding Commands to a Macro
Adding Comments to a Macro
Running a Macro from the Microsoft Visual Basic Editor
FURTHER MACRO EDITING
Removing Lines from a Macro
Using Comments to Remove Lines
USING WORKSHEET DATA IN A MACRO
Introducing Objects, Properties and Methods
Getting Information from the Active Cell
Using ActiveCell in a Macro
Dealing with Errors (Basic Error Handling)
Getting Information from Other Cells
Using Range in a Macro
VARIABLES
Introducing Variables and Variable types
Using a Variable
CONTROLLING THE FLOW OF A MACRO
Inserting a New Module
Running Statements When a Condition is Satisfied
Running Statements When a Condition is Not Satisfied
Using ElseIf to Check Several Conditions
Using Multiple Conditions in a Single Statement
Using Multiple If... Then Statements
INTERACTING WITH MACROS
Displaying a Simple Message Box
The MsgBox Function
Customising a Message Box
Using Message Box Buttons
Using Worksheet Data in a Message Box
The InputBox Function
Using an Input Box in a Macro
Getting User Input
RUNNING MACROS AUTOMATICALLY
Running a Macro When You Open a Workbook
Running a Macro When You Close a Workbook
Recording a relative macro
Recording an absolute macro
Creating a Quick Access Toolbar button
Stepping through macro created code
EXPLORING THE VISUAL BASIC EDITOR
Turn On/Off the Explorer
Turn On/Off the Properties Window
The Immediate Window
WORKING WITH MODULES
About Modules
Moving Around the Module
EDITING A MACRO
Editing a Macro
Adding Commands to a Macro
Adding Comments to a Macro
Running a Macro from the Microsoft Visual Basic Editor
FURTHER MACRO EDITING
Removing Lines from a Macro
Using Comments to Remove Lines
USING WORKSHEET DATA IN A MACRO
Introducing Objects, Properties and Methods
Getting Information from the Active Cell
Using ActiveCell in a Macro
Dealing with Errors (Basic Error Handling)
Getting Information from Other Cells
Using Range in a Macro
VARIABLES
Introducing Variables and Variable types
Using a Variable
CONTROLLING THE FLOW OF A MACRO
Inserting a New Module
Running Statements When a Condition is Satisfied
Running Statements When a Condition is Not Satisfied
Using ElseIf to Check Several Conditions
Using Multiple Conditions in a Single Statement
Using Multiple If... Then Statements
INTERACTING WITH MACROS
Displaying a Simple Message Box
The MsgBox Function
Customising a Message Box
Using Message Box Buttons
Using Worksheet Data in a Message Box
The InputBox Function
Using an Input Box in a Macro
Getting User Input
RUNNING MACROS AUTOMATICALLY
Running a Macro When You Open a Workbook
Running a Macro When You Close a Workbook
Who should attend?
Aimed at frequent users who have a working knowledge of Microsoft Excel’s Macro creation and execution, this course provides candidates with practical experience of the topics listed in the course outline.
Pre-requisites
Those attending should have an understanding of Microsoft Excel macro creation and execution, be competent Microsoft Windows users, and be familiar with the basics of file and disk management.
