Thread: Excel VBA code executing a variable as a Sub.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Dempsey John Dempsey is offline
external usenet poster
  
Posts: 2
Default 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
Reply With QuoteReply With Quote