Using "Call" command to run function in listbox

[DRH192]

Hi all,

I have a listbox on a form which lists names of functions in a module. I want to use the "Call" method to run the function selected from the list box. I have tried

Call Me.ListScripts

but it doesn't work. Any help would be greatly appreciated.

Many Thanks

 

[ZmrAbdulla]

I believe you need a select case statement to do this.


________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[DRH192]

Not sure that would work for me as I could be adding to the list on a regular basis. If there is no way of running the code directly using the "Call" method, I will create a new macro for each function and use the macro function "RunCode"

Thanks

 

[PWise]

look @ the Eval function


eval(me.listscripts)

or @ the run function

run(me.listscripts)

 

[DRH192]

Run function is perfect!

Thankyou very much