How to declare constant optional paramenters for function or sub

[is49460]

Hello,



I was trying to find a way to name constant optional parameters for a function. I have function A(optional myParameter as Integer) as Boolean.
When i make a function call I want to be able to see predefined legit values for myParameter that my "function A" can accept. I would think it should be relatively easy to define but can't find a way to do so. Please help. Thanks

[NoellaG]

You could try to declare an enum, and then use that:

for instance

Public Enum ImportFormat
Unknown = 0
FlatFile = 1
Excel = 2
XML = 3
Access = 4
End Enum

[is49460]

that's exactly what i was looking for, thanks a lot!!!