Introduction to Excel VBA
VBA stands for "Visual Basic for Applications" and is used in the Microsoft Office suite of products. It allows the writing and recording of macros, which can be used to automate various tasks within the program itself and can even be used to manipulate external files.
My own experience with VBA is almost exclusively in Microsoft Excel and it is that which will be the focus of this section of the website. Here I will provide articles offering advice on its usage and extracts of sample code that may be of use to others.
Articles and Resources
The resources below have been categorised according to their complexity and the level of programming experience required, if any. The beginner levels include plain-English guides to working with macros and do not require any programming knowledge, while the intermediate and advanced levels cover both editing existing macros and writing new ones from scratch. The intermediate and advanced categories also include annotated code samples for you to copy and work with.
|Beginner's Guide to Recording Macros||Available in both web-based and PDF formats, this is a beginner's guide to recording macros. It includes an explanation of what a macro is and some of the potential uses thereof.||15/12/16|
All media hosted on this website is copyright © Ben Lauritson 2006 - 2023 unless explicitly stated otherwise.
Disclaimer: Some sections of this website contain strong language and/or adult themes. By continuing to browse, you are waiving any right to be offended and waiving any liability on my part for the consequences thereof. If you are not old enough to understand this disclaimer then you are not old enough to continue browsing. Have a nice day.