Hi anyone out there who might be looking for this. I spent a bit of time figuring this out, and would like to share this info since I've gotten so much from the net, it's my chance to give back.

Some of you may already know this, but I'm no genius, so here it goes.

Consider this scenario. Now you may ask, why would you ever need to do this? Well, I never did need it until ... the need for it came about :-)))

My mistake was I was trying to get a reference to the function or sub including the parameters.. something like set a = getRef("somefunction('" & parameter1 & "')" .. but that failed miserably.

The solution follows...

call hub("specialA",param1,param2)

....

sub hub(dowhat,param1,param2)

'calls the appropriate sub based on parameters given

dim func

on error resume next 'here in case you haven't built the function you're about to reference in the line below..

set func = getRef("exampleSub_" & dowhat) ' first look for the sub or function by name only, in this case i'm looking for a sub or a function called "exampleSub_Speciala"

call func(param1,param2) 'here's where the magic happens

on error goto 0

end sub

'here's your sub that you're calling

sub exampleSub_specialA(param1,param2)

'do stuff here using param1 and param2 that were passed!

end sub

In case anyone else spins their wheels like me, note a couple of things:

1) Needs Subroutine/Function name as string. Not very obvious...

Sub Fu
    MsgBox "Whatever"
End Sub

Set BadRef = GetRef ( Fu)
Set GoodRef = GetRef ( "Fu")

2) Won't work with class methods

Class Toe
    Public Sub Fu
        MsgBox "Howdy"
    End Sub
End Class
'





















Set Kung = New ( Toe)
Set BadRef = GetRef ( "Kung.Fu")