[RESOLVED] Drop down values in parameters

[xor83]

how can i create function that can show parameter value in drop down? i have seen many times but don't know how to create one..

[Paul M]

Are you referring to the intellisense like in the Visual Basic 6 IDE?

[xor83]

Are you referring to the intellisense like in the Visual Basic 6 IDE?

Exactly
Like when we specify paramerter in msgbox

[Paul M]

This link discusses intellisense and some helpful code examples

[BillGeek]

You need to create an enum:

Private Enum SomeType
    SomeValue = 1
    OtherValue = 2
End Enum

Then when adding the parameter to your function, set it as this type.

Function MyFunction(aParameter As SomeType) As Integer
    MyFunction = aParameter
End Function

In which case, the return value for MyFunction will be either 1 or 2 in integer type.

Let me know if this is what you wanted to know...

[xor83]

Thanks bill thats what i am looking for