Microsoft Office Forums - View Single Post - [Solved] Can a function or sub be called using a variable name?

macropod · 12-04-2013, 06:28 PM

Quote:

Originally Posted by BobBridges

... calling a variable subroutine. Sort of like this:

Code:

Select Case MyVar
  Case 1 To 7: SubName = "MySub_" & MyVar
  Case "Binge": SubName = "MaxTime"
  Case "Micro": SubName = "Micro"
  Case Else: SubName = ""
  End Select
If SubName <> "" Then Call SubName

That won't work

True, but it would work for:

Code:

Select Case MyVar
  Case 1 To 7: Call MySub(MyVar)
  Case "Binge": Call MaxTime
  Case "Micro": Call Micro
  Case Else
End Select