Code Assistance

[jstevens]

I would like to call a sub-routine based on a series of prompts. One thing to note is that the sub-routine is not envoked immediately after the prompt.

My challenge is that I'm receiving a compile error: Expected Sub, Function or Property

Example:

Code: Select all

oPrompt = InputBox("Your Choices Are: 01, 02 or 03","Entry Required...","Please Enter Your Selection")

If oPrompt = "01" Then
    oSelection = "Run_SubRoutine_01"
ElseIF oPrompt = "02" Then
    oSelection = "Run_SubRoutine_02"
ElseIF oPrompt = "03" Then
    oSelection = "Run_SubRoutine_03"
Else
    'Do Nothing
End IF

'More code here
'More code here
'More code here
'More code here

'*************************************
'Now run the code from the prompt - The compile error happens here.  Each sub-routine ie Run_Subroutine_?? has been coded correctly.
       oSelection

Thank you for taking a look,
John

[HansV]

The line oSelection tries to execute a procedure named oSelection, it doesn't look at the value of the variable oSelection. Try

Application.Run oSelection

[jstevens]

Hans,

That will do it.

Thank you,
John