User-Defined Data Type

Office 2010
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Any data type you define using the Type statement. User-defined data types can contain one or more elements of a data type, an array, or a previously defined user-defined type. For example:

Copy 
Type MyType 
 MyName As String ' String variable stores a name. 
 MyBirthDate As Date ' Date variable stores a birthdate. 
 MySex As Integer ' Integer variable stores sex (0 for 
End Type ' female, 1 for male).
Show: