Not Covered Here

Chapters 2 and 3 give you a lot to think about. Still, there are a few things about Visual Basic I haven’t touched on. The two reasons I haven’t covered everything yet:

  • Some functions are obsolete or not particularly useful from Excel.

  • Other Visual Basic keywords are very advanced.

Table 3-23 lists the Visual Basic functions that are obsolete or aren’t often used in Excel. Table 3-24 lists advanced keywords.

Table 3-23. Obsolete or obscure Visual Basic functions

Function

Use to

Beep

Play a beep through the computer’s speaker.

Environ

Get strings from the operating system’s environment string table. For instance, Environ("path") returns the MS-DOS PATH environment variable.

Command

Get command-line arguments. Excel applications don’t use command-line arguments.

Table 3-24. Advanced Visual Basic keywords

Category

Keyword

System registry

DeleteSetting

 

GetSetting

 

GetAllSettings

 

SaveSetting

Windows APIs

Declare

 

AddressOf

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.