The following table lists Visual Basic for Applications Features not in VBScript.
| 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 ! |