About Visual Basic for Applications
Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6. Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
The abbreviation VBA will mainly be used when referring to Visual Basics for Applications.
How to download and install Visual Basic for Applications
VBA is already included in Excel, so all we have to do is to enable its shortcut. A step by step guide is shown below.
- Click on "File" and open the "Options" section in Excel
- Go to the "Customize Ribbon" section and mark off for "Developer". Click "OK".
- The VBA editor is now available under the "Developer" tab.
Getting started with Visual Basic for Applications
There are a lot of great VBA tutorials online, so if you don't find what you're looking for in this wiki, check them out.
- Check out our guide Beginner tutorials on VBA.
- Microsofts language reference for Visual Basic for Applications.
- I found the Youtube tutorials by Tiger Spreadsheet Solutions to be both informative and understandable when first learning VBA.
Some useful information when coding can also be found at Tips and tricks for coding.
Useful tutorials
Our tutorials:
Our exercises:
External tutorials: