View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_3_] Trip[_3_] is offline
external usenet poster
 
Posts: 44
Default 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