Function Auto List

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.

yup, you want an Enum


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

Code:

---

Public Enum MyEnum

    Item1 = 1
    Item2 = 2
    Item3 = 3

End Enum

---

And Declare your function Like this

Code:

---

Public Function MyFunction(MyParameter as MyEnum)

---

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

Cheers, that did the job!!