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

macropod · #15 12-05-2013, 03:24 PM

Quote:

Originally Posted by BobBridges

Is there a way in VBA to put the name of a subroutine into a variable and then call it that way, so to speak "indirectly"?

Sure there is! Try:

Code:

Dim MacroName As String, i As Long
 
Sub Demo()
i = CLng(InputBox("Which macro to run?"))
MacroName = "ThisWorkbook.Macro" & i
Application.Run MacroName
End Sub
 
Private Sub Macro1()
MsgBox "Success! You ran macro: " & i
End Sub
 
Private Sub Macro2()
MsgBox "Success! You ran: " & MacroName
End Sub
 
Private Sub Macro3()
MsgBox "Ho hum ... you ran macro 3"
End Sub

Simply input 1, 2 or 3 into the inputbox.

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