VBA for Microsoft Excel
This course will teach programming concepts and how to add functionality to a Microsoft Excel using Microsoft Visual Basic® for Applications.
At Course Completion
At the end of the course, participants will be able to:
- Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Excel applications to write custom functions and event-driven procedures.
- Validate data
- Find and trap errors
- Create a custom function for a Microsoft Excel application.
Prerequisites
Before beginning this course, participants should be able to:
- Extensive understanding of Microsoft Excel or previous version of Microsoft Excel
- Basic programming knowledge in Visual Basic
Why you should train with us?
Quality Assured
Generate New Idea
Telephone Support
Certified Instructor
Improve Productivity
SMS Support
Practical Example
Updated Resources
Email Support
Course Outline
Duration: 2 days
Module 1: Make a Macro Do Simple Tasks
- What’s the Difference between VBA and a Macro
- Creating a Simple Macro
- Changing Multiple Properties at Once
- Manipulating Recorded Properties
- Recording Methods in a Macro
Module 2: Make a Macro Do Complex Tasks
- Task One: Opening the Report file
- Task Two: Filling in Missing Labels
- Task Three: Adding a Column of Dates
Module 3: Explore Workbooks and Worksheets
- What is an object?
- Understanding Workbooks
- Understanding Worksheets
Module 4: Explore Range Object
- Referring to a Range
- Enhancing Recorded Selections
- Entering Values and Formulas into a Range
- Formatting a Range
Module 5: Explore Data Objects
- Working with Excel Tables
- Working with PivotTable Reports
Module 6: Explore Graphical Objects
- Exploring Graphical Objects
- Exploring Charts Objects
Module 7: Control Visual Basic
- Using Conditionals
- Creating Loops
Module 8: Extend Excel and Visual Basic
- Creating Custom Functions
- Handling Errors
Module 9: Launch Macros with Events
- Creating Custom Command Buttons
- Handling Worksheet and Workbook Events