VBA: Calling a procedure to run

[reallystuck]

I have written some code which prompts the user for the name of a procedure within an access database. I then want it to run the code which the user has input. Visual basic doesnt like this, anyone got any ideas?

Example:

Message box to user "Which procedure to you want to run?"

VBA then calls that procedure to run.

 

[braindead2]

I suggest you look at the inputbox verses the msgbox. You can do something like this

dim strmsg as string

strmsg = inputbox("select procedure A,B,C&quot

select case strmsg
case "A"
do this
case "B"
do this
case "C"
do this
case else
msgbox "not one of the selections"
end select

good luck