Calling a function based on the contents of a string

[MikeAJK]

Hi all, is it possible to call a function based on the name of a string?

What I want to do is treat the contents of "TextVariable" as a function name and then call it...

i.e. something similar to this:

Sub Command1_Click()
    Msgbox "Button pressed"
End Sub
 
Sub Command2_Click()
    Dim TextVariable as String
 
    TextVariable = GetFunctionNameFromDatabase()
    'i.e. TextVariable = "Command1_Click()"
 
    Call ContentsOf(TextVariable)
End Sub

cheers
- Mike.

[Muddy]

probably the closest you will get to doing this will be to put your function code in a Class Property or Method and use the CallByName function to invoke it (I think that would work anyway) ...

[MikeAJK]

okies, cheers :-)

[Shaggy Hiker]

Another thing you could do would be to make a function that took the string as an argument, and used a Select statement to choose which function to call:

Select funcName
Case "Blue"
Blue()
Case "Red"
Red()
.
.
.
etc.

[MikeAJK]

yeah that'd work,
I'm missing the obvious answers and going straight into the more complex ones as usual, ta :-)

[Shaggy Hiker]

That's when it's time to take a walk.