![]() ![]() ![]() ![]() "Module name where " & SubName & " is housed: " & vbCrLf & strModName, _Ħ4, "Information about macro being run." ![]() "Actual subroutine name:" & vbCrLf & SubName & vbCrLf & vbCrLf & _ "Full macro name:" & vbCrLf & MacroName & vbCrLf & vbCrLf & _ SubName = Application.Replace(MacroName, 1, Application.Search("!", MacroName), "")įor Each ModName In MacroName = ActiveSheet.Buttons(Application.Caller).OnAction In the macro belonging to the button you want to know about, enter this line:ĭim MacroName$, SubName$, ModArr As Variantĭim ModName As Object, strModName$, i&, j& I assume you mean it is a Forms button, which makes sense because it's a macro as you said, not a procedure written into a command button click. You can always right-click the button, left click on Assign Macro, and see the name of the macro that way.Ī programmatic approach can be as follows: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |