how describe possible values for parameter for a sub

Hello All,

I am actually doing a library of subs and functions that will be use by collegues in the office.

I would like to describe, when usefull, the list of possible values available for parameters of theses subs and functions. So when people use this sub or function, he can select one of the value in the list.

Any help will be appreciated.

Chris

I think what you want is an Enum.

Code:

---

Public Enum Answers
Answer_No
Answer_Yes
Answer_Maybe
End Enum

---

Then in your Sub or Function:

Code:

---

Public Sub MyAnswer(TheAnswer As Answers)
'your code
End Sub

---

This also works for Properties.