Part VI: Programming Excel with VBA
If you've ever wanted to do a bit more or automate routine operations so that you don't always have to perform boring, repetitious tasks manually, this part is for you. This part is also aimed at those Excel users who want to develop Excel-based applications for other users. Visual Basic for Applications (VBA) is the powerful programming language that you can use for these tasks, as well as for more esoteric purposes, such as developing that specialized worksheet function that you simply can't find in Excel.
In This Part
Chapter 38
Introducing Visual Basic for Applications
Chapter 39
Creating Custom Worksheet Functions
Chapter 40
Creating UserForms
Chapter 41
Using UserForm Controls in a Worksheet
Chapter 42
Working with Excel Events
Chapter 43
VBA Examples
Chapter 44
Creating Custom Excel Add-Ins