Loading...

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 

Prerequisites

Significant Excel experience and Intermediate Applications of Excel or equivalent experience. Students should have a solid knowledge of Excel, a strong background using conditional statements, and substantial experience working with spreadsheets before taking this class.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel Macros Using VBA
Type
Discussion
Days
W, Th
Time
8:30AM to 4:00PM
Dates
Jun 26, 2024 to Jun 27, 2024
Schedule and Location
Contact Hours
13.0
Delivery Options
Course Fee(s)
Fee non-credit $0.00
Drop Request Deadline
Jun 24, 2024
Transfer Request Deadline
Jun 24, 2024
Section Title
Excel Macros Using VBA
Type
Discussion
Days
W, Th
Time
8:30AM to 4:00PM
Dates
Jun 26, 2024 to Jun 27, 2024
Schedule and Location
Contact Hours
13.0
Location
Delivery Options
Course Fee(s)
Fee non-credit $399.00
Drop Request Deadline
Jun 24, 2024
Transfer Request Deadline
Jun 24, 2024
Required fields are indicated by .