Function Auto List

[Blade]

HI,
Is it possible to create functions that have an auto list box appear for some of its arguments, such as the ones you see with the msgbox function (where the list drops down with vbcritical, vbOk etc....). Thanks in advance, Shaun.

[Sam Finch]

yup, you want an Enum


In a public Module (or public Object) put something like this

Public Enum MyEnum

    Item1 = 1
    Item2 = 2
    Item3 = 3

End Enum

And Declare your function Like this

Public Function MyFunction(MyParameter as MyEnum)

You'll get a nice Picklist of Item1, Item2 and Item3 when you type the function call

[Blade]

Cheers, that did the job!!