Tutorial for Beginners

Welcome to the Excel Macros/VBA training for absolute beginners. Find below the list of contents for the training, which consists of 10 comprehensive lessons of approximately 30 minutes to read and understand each. Try to replicate some of the examples presented here and play around to get familiar with the programming language. Once ready with the basics, find more learning resources in this blog. Navigate Excel VBA objects and functions, check out numerous macro examples explained step-by-step, or look into more sophisticated Excel applications in the other blogs.

 

Contents:

1. Developer Tab and VBA Editor
2. Modules and Procedures
3. Excel Object Model
4. The Range Object
5. Variables
6. Conditions and Loops
7. Arrays
8. Messages and Input
9. Userforms
10. Debugging and Error Handling

You can also get a copy of the Excel VBA Guide for Beginners with extended and revised content, or some other books recommended in this site here.