Searching for function usage in Excel VBA

Question

I have inherited an Excel spreadsheet with many VBA functions and it's not clear where (or even if) a lot of them are being used.

Is there a way to find the usage of a VBA function, or perhaps search for invocations of it, similar to the way you can click on a function/method in a standard IDE and find its usage throughout the codebase? I am looking for the cells from which the functions could be being called, not invocations from within other VBA functions.

TheEngineer · Accepted Answer · 2014-12-30 18:27:52Z

3

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

On Worksheet - Use CTRL+F and make sure "Look In" is set to "Formulas." Then click "Find All" to find each usage of the function name in the worksheet.

edited Dec 30, 2014 at 18:27

answered Dec 30, 2014 at 18:11

TheEngineer

1,2251 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sparc_spread Over a year ago

I'm sorry, I meant to say that I was looking for cells on the sheet where the function may be called, not from within other VBA functions. I'll edit question appropriately - thx.

TheEngineer Over a year ago

You can use the Find method on the sheet to look for function names as well. Just make sure that "Look in:" is set to "Formulas". You can then click "Find All" to see all instances where the function is used.

Collectives™ on Stack Overflow

Searching for function usage in Excel VBA

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related