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).
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.