how describe possible values for parameter for a sub

[Chris ZANARDI]

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

[WizBang]

I think what you want is an Enum.

Public Enum Answers
Answer_No
Answer_Yes
Answer_Maybe
End Enum

Then in your Sub or Function:

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

This also works for Properties.