Control the long integer value assigned to each item in the list, simply set the constant equal to a value : Enum « Data Type « VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

VBA / Excel / Access / Word » Data Type » Enum

Control the long integer value assigned to each item in the list, simply set the constant equal to a value

 

'Working with Enumerated Types

Public Enum PersonTypeList

    Client = 10

    PersonalContact = 5

    Vendor = 2

    Other = 999

End Enum



Sub EnumM()

   Dim pt As PersonTypeList

   pt = Client

   

   Debug.Print pt



End Sub

Related examples in the same category

1.	Working with Enumerated Types
2.	Creating an Enum

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.