Alveare Learning

This course is aimed at beginners in VBA, ideally someone who has very little experience, but at least has heard of VBA and Macros.

VBA is one of the most useful and most-used languages. Being able to extend the functionality of office products such as Excel can help you save time and money in an ever-demanding workplace

What You Will Learn

This course aims to teach you the fundamentals of VBA. Whilst we're using Excel, the basic principles you will learn can be applied to any VBA environment, and not only that, extended to other programming languages as most are very similar.

This course will take you from declaring variables through to examples of VBA. We'll cover many common concepts and I'll share tips to help you start off on the right path, reducing stumbling blocks as you progress to more advanced concepts.

What You'll Be Able To Do Once The Course Is Complete

• Understand how to use the VBA Editor
• Understand how and where different VBA Containers such as "Modules" are used
• Understand Reading & Writing Variables
• Understand where to place your code
• Understand how to make re-usable code, passing parameters and returning results
• Build your own basic class
• Debug your own program, or someone else's program
• Understand the different ways data can be obtained and interacted with
• Understand how to work with Arrays and Custom Structures (Types)
• Understand how to use the most common statements such as IF and Case

This Course Is A Text Based Course

There's a good reason for this. With VBA being a text based language, it's incredibly boring to listen and watch someone else type it. It's much quicker to copy code yourself and then give it a go.