VBA: Visual Basic For Applications - The Basics: Everything you need to know to get started with VBA in Excel, or any other environment

by Liam Bee

This book 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 book 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 Book Is CompleteUnderstand how to use the VBA EditorUnderstand how and where different VBA Containers such as "Modules" are usedUnderstand Reading & Writing VariablesUnderstand where to place your codeUnderstand how to make re-usable code, passing parameters and returning resultsBuild your own basic classDebug your own program, or someone else's programUnderstand the different ways data can be obtained and interacted withUnderstand how to work with Arrays and Custom Structures (Types)Understand how to use the most common statements such as IF and Case

117 pages, Kindle Edition

Published February 27, 2022