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