In order to scroll to the macro named myMacro in a VBE Standard Module, I can write code like this:
[vba]Sub scrollToMyMacro()
Application.GoTo "myMacro"
End Sub[/vba]
I can assign this Sub to a button on any sheet and it will instantly teleport to myMacro. The VBE will be opened if it's not open, and the Standard Module containing myMacro will be brought to the front with the cursor positioned at the start of Line1.
This works amazingly well for such a simple command, but I can't get it to work if myMacro lives in a Class Module or in an Addin.
I'd like to be able to jump to a macro that lives in a Userform Module. Is that possible?