Hi, Is it easy to create custom xl consts that can be used as function
parameters?
At the moment I'm using a standard module containing my initialised
constants but I want the VB editor to prompt with a list of permissible
parameter values as it does for inbuilt functions. (Ideally I would like
something along the lines of:

private sub myFunction(myParameter as myType)
....
end sub

Type myType
myVariable1 as integer = 0
myVariable2 as integer = 1
end Type
)


Any suggestions? Thanks in advance