View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_3_] Andrew[_3_] is offline
external usenet poster
 
Posts: 15
Default Call a procedure whose name is stored in a variable

Hi all

Is there a way of calling a procedure, the name of which is stored in
a variable?

I am trying to create a class object to encapsulate a timer function.
The idea is that you would instantiate the object and set a property
which determines which procedure to call. Evidently, this property let
procedure will use a private string variable to store the information,
and so at some point I'll need to have code along the lines of

Call [strProcedureName]

However, I can't get this to work.... any ideas?

Thanks a lot

Andrew