Thread
:
Call a procedure whose name is stored in a variable
View Single Post
#
2
Posted to microsoft.public.excel.programming
papou[_2_]
external usenet poster
Posts: 112
Call a procedure whose name is stored in a variable
Hello Andrew
How about
:
Application.Run strProcedureName
HTH
Cordially
Pascal
"Andrew" a écrit dans le message de news:
...
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
Reply With Quote
papou[_2_]
View Public Profile
Find all posts by papou[_2_]