calling function using variable as its name

[uprichard]

I need to be able to call a function depending on the contents of a variable i.e

sMyVar = "Func_To_Call"
call sMyVar

Where the above would call "Func_To_Call". In other languages I could use the eval statement. Can it be done in VB?

I would also like the function to be in a side file that could be included at run time once the user has decided which function to run. Is that possible?

 

[PHV]

Depending of the application hosting the VBA code take a look at Eval or Application.Run

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244