Skip to main content

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>