Reputation: 342
I have an add on with lots of modules and userforms. Of course there is a lot of nesting and macro referrals in each macro. I was wondering if there is a shortcut I am not aware of to find these macros that are referenced, or if I have to go through each modules manually to find them?
In Matlab the shortcut is Ctrl+D and then the IDE would automatically open the script/function highlighted.
Upvotes: 2
Views: 92
Reputation: 1872
When you have the cursor on the Function Call....hit Shift+F2 and it takes you to that function.
You can also hit Ctrl+Shift+F2 to cycle back to the last few cursor locations...not quite as helpful as jumping to the procedure/function header, but if you are just scrolling around following code, you can easily go back and forth.
One trick you can use is in the called function/sub comment out a line with the calling function/subs name...then while you are bouncing around in the code working through something, you can uncomment that line and Shift+F2 back to the calling function/sub.
Hope that makes sense...
Sub Main()
ExampleSub <----Stick your cursor in the name and hit Shift+F2 to jump to the header
End Sub
Sub ExampleSub <----You'll jump here
'Main 'Calling Proc <----You can use this to jump back to Main if you uncomment it
'Do Stuff
End Sub
Upvotes: 3