• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

II. The VBA Programming Language > 7. Built-in Functions and Statements

Chapter 7. Built-in Functions and Statements

VBA has a large number of built-in functions and statements. For possible reference, Table 7-1 shows the VBA functions, and Table 7-2 shows the statements. We will take a look at a few of the more commonly used functions and statements for programming Excel VBA in this chapter and Chapter 8.

To help simplify the exposition, we will follow Microsoft’s lead and use square brackets to indicate optional parameters. Thus, for instance, the second parameter in the following procedure is optional:

Sub ChangeFormat(FontName [, FontSize])

Note that we have also omitted the data type declarations, which will be discussed separately.

Table 7-1. VBA Functions[1]

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint