View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Can I use a variable contain the name of a sub or function tocall it?

A bit more clarification??


On Nov 23, 8:35*am, wrote:
I would like to be able to *decide at run time which of several subs to
call and, when writing the code, it may be impossible to even know the name
of the sub.

That is, I cannot use code like:
* * * * if i 5 then
* * * * * * * * call This()
* * * * else
* * * * * * * * call That()
* * * * endif

because I have no idea what the names of "This" or "That" may be.

I would like to do something equivalent to:
* * * * Sub MyCode(SubName as WhateverIsNeeded)
* * * * * * * * Call SubName
* * * * End Sub

Thanks for any help.