PDA

View Full Version : [SOLVED:] Creating a Function parameter pick list



Paul_Hossler
11-19-2015, 03:02 PM
I was using the CONVERT() function and realized that there is a pickable list of valid parameters

Is there anyway to do something similar for a UDF?

I did look at Application.MacroOptions, but didn't see anything


14802

SamT
11-19-2015, 03:21 PM
Enums?

Function UDF(Value1 As Enum, Value2As Enum) As Type
Dim MyVar
Select Case Value1
Case enumVar1: MyVar = X

XP doesn't have selectable lists, so... :dunno

Bob Phillips
11-19-2015, 03:37 PM
In short, no you can't.