Microsoft Office Tutorials and References
In Depth Information
Create Your Own Functions
6. Click OK.
The dialog box opens, ready to receive the arguments; see Figure 18-13.
Isn’t this incredible? It’s as if you are creating an extension to Excel, and
in essence you are.
This is a very basic example of what you can do by writing your own
function. The possibilities are endless, but, of course, you need to know how to
program VBA. I suggest reading Excel VBA Programming For Dummies, by
John Walkenbach (Wiley).