VBA Training Course
Description
You can easily learn VBA by working your way through the variety of free lessons that we offer.
If you think that creating macros is too complicated or beyond your capacity, don’t worry, this course is intended for those of us who are just starting out in programming, so it starts from zero.
Just like our Excel course, these lessons have lots of examples, and we’ve simplified them as much as possible so that it’s easy to learn VBA.
We recommend that you work your way through the lessons in the order in which they are provided, because at each level you will need the skills acquired in the previous ones.
Topics for this course
1 Lessons30h
VBA Training Course
LESSON 1
Introduction
First macro
LESSON 2
Selections
Properties
Colors
LESSON 3
Variables
Variables (continued)
LESSON 4
Conditions
Conditions (continued)
LESSON 5
Loops
Loops (exercise)
LESSON 6
Procedures and functions
LESSON 7
Dialog Boxes
LESSON 8
Workbook events
Worksheet events
LESSON 9
UserForm
Controls
Controls (continued)
Controls (exercise)
LESSON 10
Arrays
Arrays (continued)
Arrays (exercise)
LESSON 11
Using Excel functions
Create a custom function
TIPS
VBA Tips