ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Call a procedure whose name is stored in a variable (https://www.excelbanter.com/excel-programming/398662-call-procedure-whose-name-stored-variable.html)

Andrew[_3_]

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


papou[_2_]

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




Andrew[_3_]

Call a procedure whose name is stored in a variable
 
On 4 Oct, 13:03, "papou" wrote:
Hello Andrew
How about:
Application.Run strProcedureName

HTH
Cordially
Pascal

"Andrew" a écrit dans le message de news:
om...



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- Hide quoted text -


- Show quoted text -


Hi

Thanks for that. This certainly works so thanks for that. I've another
question, regarding calling a proc from Application.OnTime, but it's
not really related so I'll do a separate post.

Thanks again

Andrew



All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com