Code VBA “Find Procedure” — Focused Search for Excel Object Procedures

The Find Procedure command under a selected Office application object the Code VBA Object menu is designed to help you quickly locate all procedures related to that object that contain a specific word. “Find Procedure” is supported for Excel, MS Access, Word, PowerPoint and Outlook.

Find custom procedures Navigating your own code is made easy by the Code Explorer which in addition to showing which procedures are in a module also lets you access related procedures (Used and Used By).

Focused Search for Excel Object Procedures

When you select an object such as Sheet1 and choose Find, a search box appears. Typing a keyword (for example, special) instantly lists every procedure connected to that object that includes the term — such as PasteSpecial, Cells.SpecialCells, or one of the many others.

Each result shows a short code preview and description, allowing you to easily identify the required procedure. This feature applies specifically to built in objects of the current Office application (not custom classes).

Semantic search is supported in a limited way, For example typing Hid would propose Hidden and when selected would also return related Visible properties - and visa versa.

By narrowing the search to the active application's object model, Find Procedure becomes a precise, context aware tool for exploring how Excel objects are used throughout your VBA codebase.