Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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:

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

© 2015 Microsoft