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

BobBridges · #9 12-04-2013, 08:47 AM

Oh, I see. But his question (it seems to me) isn't about passing values to subroutines; it's about 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, but what he's asking (I think) is how to do that sort of thing. If MyVar happens to be 5, then he wants his program to Call MySub_5; if it's "Binge" he wants to Call MaxTime; and so on.

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