Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 ! |