Finding Function Usage in Excel VBA

Question

I have inherited an Excel spreadsheet with many VBA functions, and it is not clear where (or even if) many of them are used.

Is there a way to find the use of a VBA function, or perhaps look for its calls, similar to how you can click on a function / method in the standard IDE and find its use throughout the code base? I am looking for cells from which functions can be called, not calls from other VBA functions.

Answer 1

In VBA - use CTRL + F and select "Current Project" to find each use of the function name in the project.

. CTRL + F , "Look In" "". " ", .