View Full Version : [SOLVED:] Getting the Name of the Calling Macro
Cyberdude
04-02-2005, 01:34 PM
Does VBA have a way for an executing macro to determine the name of the macro that called it?
Jacob Hilderbrand
04-02-2005, 01:58 PM
You can setup your macros like this.
Option Explicit
Sub MyMacro()
Call Macro1("MyMacro")
End Sub
Sub Macro1(Optional MyCaller As String)
MsgBox MyCaller
End Sub
Cyberdude
04-02-2005, 02:01 PM
Yeah, I've taken that approach before, but somehow it seems clumsy to me. I'd really prefer executing a VBA command of some sort, if such exists. Thanx for the reply.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.