This course is for anyone who wants to learn Visual Basic for Applications (VBA). Typically, participants have advanced knowledge of Microsoft Excel to be ready for programming in VBA. VBA is often used when a series of actions is repeatedly performed. By coding your sequence of actions in VBA, you can automate this process, saving lots of time. The course does not require any prior programming experience.
We begin by using Microsoft Excel’s macro recorder and then learn to interpret and edit the underlying code. Participants will then learn how to work within modules to build macros (subprocedures) and user-defined functions. Programming topics that will be covered include: declaring variables, looping, debugging, creating input and message boxes, using logic in your code, working with controls and building userforms. This course is hands-on and participants are expected to have computers and follow along with the instruction.
Course Objectives
By the end of the course, the participants will be able to:
- Record and edit VBA macros (subprocedures)
- Create user-defined functions (UDFs)
- Declare and work with different types of variables
- Incorporate existing Excel functions inside the VBA code
- Understand how to debug your code
- Use looping to efficiently repeat certain actions
- Incorporate logic in your code
- Extract and user inputs through input and message boxes
- Work with controls and build userforms
Suggested Prerequisites:Advanced knowledge of Microsoft Excel
Program Level: Advanced
Advance Preparation: None
Computers and Financial Calculators: Laptops are required during the training
Recommended CPE Credits: 7