VB Language

User-Defined Types

Brian Element

A user-defined type (UDT) allows the programmer to define custom data elements that are specifically suited for the data at hand. A UDT can contain two or more elements, each element being a variable or array. UDTs are defined with the Type...End Type statement.

Variant

Brian Element

Variant is VBA’s most flexible data type as well as the default type. The Variant data type can hold almost any type of data, the exceptions being fixedlength strings and user-defined types. The downside is that Variant data requires more memory to store, and more computer power to process, than other data types.

Weekday()

Brian Element

Returns a value 1–7 representing the day of the week. The optional firstdayofweek argument specifies the first day of the week; the default is Sunday. The firstdayofweek option in IDEAScript does not seem to work.

With...End With

Brian Element

The With...End With construct cannot be called a control statement because it does not modify code execution. It does, however, provide a handy shorthand that simplifies writing code in certain situations.