Searching within VBE

[PipBoy808]

I'm dealing with a workbook with lots of diffeent modules containing VBA that are working behind the scenesand weren't written by me. Is there any way to search for keywords in VBE or to search specifically for functions so as to more easily locate known bits of code ?

 

[Debraj]

Hi PipBoy..

Just want to light on two things..


* In Find Box, in VBE, you can search for a string, within

• Current Procedure,
• Current Module
• or Current Project, which will search in entire Project including class and other modules..

* In any keyword, if it was define in the Project..
Right Click in the keyword, and select Defination
It will jump directly to the Dim section of variable or Function section.. where it was defined.. in other Module also.. In the attached pic, it will jump to the BBColor define section..

 

[NARAYANK991]

Hi ,

You may want to go through this link :

http://dailydoseofexcel.com/archive...umenting-tools-project-analyzer-and-visustin/

and check out the trial version of the software here :

http://www.aivosto.com/vbcatalog.html

Narayan