User-Defined Types

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.

Each element follows the same rule as regular VBA variables. You can mix data types in a UDT as dictated by the needs of your program, and you can use any available type. An element can be an array as well as another UDT.

The definition of a UDT must be placed in a module, outside of any procedures.