Visual Basic for Applications Features Not in VBScript
Contents
Category Omitted Feature/Keyword Array Handling Array function
Option Base
Private, Public
Declaring arrays with lower bound <> 0Collection Add, Count, Item, Remove
Access to collections using ! character (e.g., MyCollection!Foo)Conditional Compilation #Const
#If...Then...#ElseConstants/Literals Const
All intrinsic constants
Type-declaration characters (e.g., 256&)Control Flow DoEvents
For Each...Next
GoSub ... Return, GoTo
On Error GoTo
On ... GoSub, On ... GoTo
Line numbers, Line labels
With ... End WithConversion CCur, CVar, CVDate
Format
Str, ValData Types All intrinsic data types except Variant
Type ... End TypeDate/Time Date statement, Time statement
TimerDDE LinkExecute, LinkPoke, LinkRequest, LinkSend Debugging Debug.Print
End, StopDeclaration Declare (for declaring DLLs)
Property Get, Property Let, Property Set
Public, Private, Static
ParamArray, Optional
NewError Handling Erl
Error
On Error ... Resume
Resume, Resume NextFile Input/Output All Financial All financial functions Object Manipulation GetObject
TypeOfObjects Clipboard
CollectionOperators Like Options Deftype
Option Base
Option Compare
Option Private ModuleStrings Fixed-length strings
LSet, RSet
Mid Statement
StrConvUsing Objects TypeName
Collection access using !