Creating ActiveX property list dropdown

[Stacey_Bauer]

I am playing around with ActiveX controls and adding new properties for the control. I can add properties defined as boolean, string and integer. What I want to be able to do is add a property that appears as a selection list (dropdown list box) in the properties window when the new ActiveX control is placed on a form.

This has got to be a piece of cake for someone. I just don't want to spend a bunch of time digging for the answer. I have a few ideas (property array? -- indexedvalue??), but don't want to spend too much time digging.

Thanks:

[ChiefRB]

mmmmm chocolate cake...

It is easy actually. All you have to do is use an Enum. I know I know, a strange new word (or maybe not). Well they work like this:

Enum myConstants
  Chiefy = 0
  IsAGod = 1
  Wooo = 2
End Enum

Simple huh?
Then, when you're declaring your property, simply use the constant type instead of an Integer... like this:

Public Property Get myProp() As myConstants
End Property

Public Property Let myProp(ByVal NewProp As myConstants)
End Property