VBA IDE subs that have "ac" type default options

[RustyAfro]

I am not sure how to word this question and hence I haven't had luck finding an answer either.

I want to make a sub or a function that requires variables, but in the IDE, show the options available to select.

For example,

in the "msgbox" function, when you type "msgbox", the message, then a comma, a list of values appear to select such as "vbcritical".

I want to make my own subs and functions can be called and also have a list of values to select. I would greatly appreciate any help figuring that out.

Thanks ;-)

 

[PHV]

Have a look at Enum

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RustyAfro]

That does seem to be what I am looking for. Does Access 97 support Enum though? I can't seem to get it to work :-/

 

[ESquared]

post some code.

 

[TonyJollans]

Does Access 97 support Enum

No.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[RustyAfro]

Thanks Tony. I looked around and there doesn't seem to be any quick workaround either for Access 97's lack of Enum support. Bummer. My company really needs to upgrade...lol

 

[ESquared]

Hey, ten years isn't so bad. In the computer world, that's only like, hmmm... let's see... carry the one... aha! An eternity.