So, I am an experienced programmer and have started to do some VBA coding. It's extremely easy, but I have one stupid problem. I'm editing an existing macro in VBA and in pretty much any IDE I've used (with a real programming language), there is a way to find where a function (sub, etc) gets called in the code. Can I not do this in Excel's editor or is there a shortcut to do it at all?

Thanks.

If you're looking for a bespoke function, try changing the name of it and then compiling the code. Each instance will then be flagged up as an error.

That seems ridiculous that it doesn't have that functionality, but if changing the function name is the only way to do it then I guess I'll do it then. Thanks.

You're welcome!

(I didn't say that it was the only way... If your code is restricted to one or two modules, you can also try ^F, but you'd need to search each one.)

I agree with you: it is a hole in the VBA IDE's functionality. The VBA IDE hasn't been updated for 10+ years, so we suffer from this sort of thing.

I use MZ Tools for this. It's a free and indispensable tool for any VBA programmer which has lots of other useful features.
Once it's installed, you place the mouse cursor in the procedure and go to Tools > MZ Tools > Procedure Callers, and it gives you a tree showing the callers.