Function Call Specified at Run Time rather than Compile Time?
 

I want to call a function which is specified at call time rather than
compile time.

In other words I need to do something like
Call FunctionNamed(X)( Arg1, Arg2,...)
which would involk the Function Named "X" with the associated arg list.

Is there a way to do this in VBA?
Thanks,
Mac Lingo

Function Call Specified at Run Time rather than Compile Time?
 

sFuncName = "MyMacro"
Application.Run sFuncName, arg1, arg2

--
Regards,
Tom Ogilvy


"Mac Lingo" wrote in message
ink.net...
I want to call a function which is specified at call time rather than
compile time.

In other words I need to do something like
Call FunctionNamed(X)( Arg1, Arg2,...)
which would involk the Function Named "X" with the associated arg list.

Is there a way to do this in VBA?
Thanks,
Mac Lingo