Visual Basic for Applications Features Not In VBScript

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 !