The following table lists Visual Basic for Applications Features not in VBScript.
Features
| Category | Omitted Feature/Keyword |
|---|---|
|
Array Handling |
Option Base Declaring arrays with lower bound <> 0 |
|
Collection |
Add, Count, Item, Remove Access to collections using ! character |
|
Conditional Compilation |
#Const #If...Then...#Else |
|
Control Flow |
DoEvents GoSub...Return, GoTo On Error GoTo On...GoSub, On...GoTo Line numbers, Line labels |
|
Conversion |
CVar, CVDate Str, Val |
|
Data Types |
All intrinsic data types except Variant Type...End Type |
|
Date/Time |
Date statement, Time statement |
|
DDE |
LinkExecute, LinkPoke, LinkRequest, LinkSend |
|
Debugging |
Debug.Print End, Stop |
|
Declaration |
Declare (for declaring DLLs) Optional ParamArray Static |
|
Error Handling |
Erl Error Resume, Resume Next |
|
File Input/Output |
All traditional Basic file I/O |
|
Financial |
All financial functions |
|
Object Manipulation |
TypeOf |
|
Objects |
Clipboard Collection |
|
Operators |
Like |
|
Options |
Deftype Option Base Option Compare Option Private Module |
|
Select Case |
Expressions containing Is keyword or any comparison operators Expressions containing a range of values using the To keyword. |
|
Strings |
Fixed-length strings LSet, RSet Mid Statement StrConv |
|
Using Objects |
Collection access using ! |