I
f you’ve ever wanted to do a bit more or automate rou-
tine operations so that you don’t always have to per-
form 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. VBA —
Visual Basic for Applications — is the powerful program-
ming 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 39
Introducing Visual Basic for
Applications
Chapter 40
Creating Custom Worksheet
Functions
Chapter 41
Introducing UserForms
Chapter 42
Using UserForm Controls in a
Worksheet
Chapter 43
Working with Excel’s Events
Chapter 44
VBA Examples
Chapter 45
Creating Custom Excel Add-InsPart VI
Programming Excel
with VBA
47_474877-pp06.indd 79347_474877-pp06.indd 793 3/29/10 11:48 PM3/29/10 11:48 PM