SP931 - Excel Macros Using VBA

Course Description

Discover the power of macros by using Visual Basic for Applications to automate your Excel applications. Visual Basic terminology, such as procedures, methods, properties, and objects will be introduced and used to create and edit Excel macros. Understand how to modify recorded macros and write original macros using Visual Basic to customize your interface and create dialog boxes for input and messages. Additional topics include using control structures, such as conditionals and loops.

By the end of this course, you will be able to: 

• Recording a macro 

• Running a recorded macro 

• Viewing and editing a macro 

• Creating a macro with absolute or relative cell references 

• Creating short cut keys or menu buttons on the toolbars to run a macro 

• Learn how to use subroutines and functions in a macro 

• Learn about VBA’s Object Model from the Application to any object on the worksheet 

• Use a dialog box to get information from a user 

• Use Message Boxes 

• Use buttons (and use the button to call a macro) 

• Use variables to store information, specify their types and scopes based on your needs 

• Use If-Then logic to control your macro 

• Learn about loops to repeat an action 

• Learn how to pick a range and modify an entire range at once 

• Create an order form 

Applies Towards the Following Certificates

• Excel Certificate : Approved Course Substitutions