User-Defined Data Type

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:

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: