View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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