Page 195 - Excel Progamming Weekend Crash Course

k540629 ch13.qxd 9/2/03 9:34 AM Page 170

170 Saturday Afternoon

REVIEW
Excel provides a rich library of worksheet functions for financial, mathematical, and other
calculations.
Your VBA program can use Excel’s worksheet functions by including them in formulas
that are inserted into cells.
The date and time worksheet functions are similar to VBA’s date and time functions,
representing dates and times as serial numbers.
The WorksheetFunction object enables you to use Excel worksheet functions in your
VBA code.

QUIZ YOURSELF
1. How is a worksheet function different from a VBA function? (See the “VBA
Functions or Excel Functions?” sidebar.)
2. How do you use a worksheet function in a worksheet formula? (See the “Using
Excel Functions in Formulas” section.)
3. Can you use the date and time worksheet functions with dates prior to January 1,
1900? (See the “Date and Time Functions” section.)