Can a function or sub be called using a variable name?

macropod · #10 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
excel where is procedure being called from	davids67	Excel Programming	1	11-18-2011 06:48 AM
What is this symbol called as?	Franky	Word	3	11-12-2011 08:16 AM
What is this right-click sub-menu called?	wornways	Word	3	08-13-2010 09:17 PM