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 |
---|---|
|
Play a beep through the computer’s speaker. |
|
Get strings from the operating system’s environment string table. For instance, |
|
Get command-line arguments. Excel applications don’t use command-line arguments. |
Table 3-24. Advanced Visual Basic keywords
Category |
Keyword |
---|---|
System registry |
|
| |
| |
| |
Windows APIs |
|
|
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.