Excel 2007 VBA Programming with XML and ASP

Chapter 5Chapter 5

VBA Procedures:

Subroutines and

Functions

About Function Procedures + Creating a Function Proce-

dure + Executing a Function Procedure + Ensuring

Availability of Your Custom Functions + Passing Argu-

ments + Specifying Argument Types + Passing

Arguments by Reference and Value + Using Optional

Arguments + Locating Built-in Functions + Using the

MsgBox Function + Using the InputBox Function + Using

the InputBox Method + Using Master Procedures and

Subprocedures + Chapter Summary

125

Earlier in this book you learned that a procedure is a group ...