User-defined data type

Any data type that you define by 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). 

See also

• Data type summary
• Visual Basic how-to topics

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.