Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should Enum create a selection Box?
I've created a small enumeration the declaration section of a module:
Public Enum REOrderType Level_1 = 1 Level_2 = 2 Level_3 = 3 Level_4 = 4 Profit_Objective = 5 Stop_Loss = 6 End Enum I had expected that when I now type REOrderType = .... that I would get a drop-down box presenting me with the options (otherwise I have to remember exactly how I spelt all the options). Am I doing something wrong?? Or, is this just the way it's supposed to work? Thanks! Trip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should Enum create a selection Box?
An Enum establishes a 'type' of a list. You then have to create a
variable of that type. So, if you have Public Enum EROrderType ... End Enum sub abc() dim x as REOrderType Now, when you type in 'x=' (w/o the quotes), you will see the drop down list. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... I've created a small enumeration the declaration section of a module: Public Enum REOrderType Level_1 = 1 Level_2 = 2 Level_3 = 3 Level_4 = 4 Profit_Objective = 5 Stop_Loss = 6 End Enum I had expected that when I now type REOrderType = .... that I would get a drop-down box presenting me with the options (otherwise I have to remember exactly how I spelt all the options). Am I doing something wrong?? Or, is this just the way it's supposed to work? Thanks! Trip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 Enum | Excel Programming | |||
Enum | Excel Programming | |||
Enum in Excel 97 | Excel Programming | |||
Enum in Excel 97 | Excel Programming |