I want to use a string variable to formulate the name of
the function to call, I can create the name in a string
variable, but how do you use the variable to call the
function.
e.g. Str1=MyFunction1
I tried str1(arg1) and it didnt work.
If I use Myfunction1(arg1) then it works . I know there
must be a special way to call functions if the name is in
a variable. Thanks

I believe you are looking for the "Run" command. Here's a small demo.

Function MyFunction(x)
MyFunction = 2 * x
End Function


Sub Main()
Dim n
Dim s

s = "MyFunction"
n = 3

Debug.Print Run(s, n)
End Sub

HTH. :)
--
Dana DeLouis
Win XP & Office 2003


"Mel" wrote in message
...
I want to use a string variable to formulate the name of
the function to call, I can create the name in a string
variable, but how do you use the variable to call the
function.
e.g. Str1=MyFunction1
I tried str1(arg1) and it didnt work.
If I use Myfunction1(arg1) then it works . I know there
must be a special way to call functions if the name is in
a variable. Thanks