18.1 Introduction
Effectively utilize the VBA editor, including the immediate window, the local variables, and the watch window.
Become familiar with basic VBA code and syntax.
Write a VBA sub procedure to process currently selected data in a worksheet.
Write basic VBA user-defined functions.
Record macros to discover VBA methods and properties.
In this lesson, we cover the basics of Microsoft’s Visual Basic for Applications, which is more commonly referred to as just VBA. This is the underlying language found in Excel and other Microsoft Office products. Some of you may have used VBA at work or might even be taking the VBA course.
VBA has two primary purposes: the first is to automate spreadsheets, and the second is to create your own functions. In this lesson, we will explore spreadsheet automation to get you familiar with some of the basics of VBA. However, the following lessons will be oriented around creating custom worksheet functions. For this lesson, we will use the following worksheet, which contains the names and addresses of a number of clients. Go ahead and open it now.