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 |
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 |
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