| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA code executing a variable as a Sub.
I have a If ....Else ....Then with code:
ElseIf szSelectedReport = "204" Then RunReport204 ElseIf szSelectedReport = "205" Then RunReport205 ElseIf szSelectedReport = "220" Then RunReport220 This goes on for sometime and what I want to produce is a shortened version i.e. Dim szReport As String szReport = CDbl(szSelectedReport) szReport = "RunReport" & szReport szReport So the Sub is called RunReport222 and I have created that but I dont know how to tell VB to now run that Sub. Can anyone help me please. Regards John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| QUERY & HELP: so slow executing VBA code... :S | Excel Worksheet Functions | |||
| code sample for executing a VB function in Excel using perl | Excel Worksheet Functions | |||
| Problems executing Excel VBA code in Microsoft Office 2003 | Excel Programming | |||
| executing macros with variable names | Excel Programming | |||
| executing code when a module opens | Excel Programming | |||
Threaded Mode
