Parameter as a list

[IT Couple]

Hi

If I type in VB msgbox "prompt", at this point I have a list of available options vbAbortRetryIgn ore... vbApplicationMo dal... and so on

Is there a way to create a sub routine with similar parameter which appear as a list. I want my partner to be able to use the procedure and select Edit, Add, Delete from a list instead of typing it (to avoid confusion).

Many thanks in advanced.
Emil

[FishVal]

You have to declare a type for an enumeration using "Enum" instruction. Then declare your subroutine argument as type of this enumeration.

[IT Couple]

Thanks FishVal that is excellent.

I must admit I have studied in the past but didn't get the use of it until now when I needed it :)

Thanks for your help.

[FishVal]

You are quite welcome. :)