
Chapter 11 VBA Programming252
the list of worksheet functions for you to choose when you type WorksheetFunction
followed by a period in the code window.
Example 11.1 Interactive Coin Toss Worksheet
With what we have learned so far about VBA and macro coding, let us put these ideas
together to create an interactive worksheet by writing two macros. Both macros will be
Table 11.2 Some of VBA’s Built-in Functions
Function Description
Asc(string) The argument is a string; the function
returns the character code of the first letter
in the string.
Int(number) Returns the integer portion of a number.
Rnd
Returns a random number between 0 and 1.
LCase(string) ...