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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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