vba code navigation
Please add 'cross references' in the code for navigation. e.g. where a function/sub is called, if the user doubleclicks or crtl+clicks on the function/sub then they get taken to it
Mathieu Guindon commented
Rubberduck enhances VBE's navigational capabilities already, and as of the last few pre-release builds also massively enhances auto-completion in the editor, not to mention all the other features, from unit testing to refactorings and static code analysis.
richard daniels commented
take a look at MZTools this VBE addin provides thie functionality and much more
Zev Spitz commented
VS Code already supports this; vote here (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/20010145-integrate-vs-code-into-excel-at-the-same-level-as) for integrating VS Code into Excel.