| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call a procedure using a variable | Excel Programming | |||
| Can a variable be used when declaring an API call ? | Excel Programming | |||
| Call procedure using variable | Excel Programming | |||
| can I call a procedure using a variable | Excel Programming | |||
| Using variable to call worksheets | Excel Programming | |||
![Don Guillett[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
