Working with Enumerated Types : Enum « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Enum

Working with Enumerated Types

 

'
Public Enum PersonTypeList
    Client
    PersonalContact
    Vendor
    Other
End Enum

Sub EnumM()
   Dim pt As PersonTypeList
   pt = Client
   
   Debug.Print pt

End Sub








Related examples in the same category

1.Control the long integer value assigned to each item in the list, simply set the constant equal to a value
2.Creating an Enum