Course Overview
This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.
Course Objectives
Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
1 - Introduction
2 - Getting Started with VBA
- Adding the Developer Toolbar
- Understanding the VBA Editor
- Recording a Macro in Personal
- Understanding the Elements of the VBA Language
- Understanding Methods
- Understanding Comments
- Working with the Range Property and Worksheet Object
- Adding a Macro Button to a Spreadsheet
- Working with the ActiveCell Object
- Working with the Offset Property
3 - Working with Variables
- Understanding Variables
- Working with Integer Variables
- Understanding Option Explicit
- Working with Other Variable Types
4 - Working with Conditional Logic
- Working with IF Statements
- Working with ELSE
- Working with ELSEIF
- Understanding Conditional Operators
- Working with NOT, AND, and OR
- Working with Nested IF
- Working with Select Case
- Working with WITH and End WITH
5 - Working with Strings and String Functions
- Working with Text Strings
- Working with LCASE and UCASE Functions
- Working with LEN and TRIM Functions
- Working with LEFT, RIGHT, and MID Functions
6 - Working with Loops
- Understanding Loops
- Working with For Next Loops
- Working with For Each Loops
- Working with Cells Property
- Working with Do Until Loops
- Working with Do While Loops
7 - Working with Sub Procedures Options and Functions
- Calling Sub Procedures
- Working with Exit Sub
- Working with Message Boxes
- Working with Input Boxes
- Working with VBA Functions
- Working with Object Variable and Set
8 - Working with User Forms
- Understanding and Creating a User Form
- Adding Controls to a User Form
- Adding Code for a User Form
- Launching a User Form from Excel
9 - Debugging your Code
- Getting Started with Debugging
- Stepping Through Your Code
- Working with Breakpoints
- Working with the Immediate Window
- Working with the Locals Window
- Working with the Err Object
10 - Conclusion