Tracking source VBA

[nhulang]

Hi there,

I'm trying to modify some code on a file that has about 30 different modules without any descriptions. Is there a way I can track back to see which module has the code assigned to populate the cells I want the code modified for?

Kind of like "find connections" in excel?

Many thanks!!

 

[GJSBED]

Not that I know of, but you can either read all the code till it starts talking about the cells in question. which is a cure for insomnia!
OR my preferred method is to use a couple of monitors and have the vba code on one and the spreadsheet on the other and watch what happens as you step through line by line using the F8 key. (you can do it with one monitor but have to keep switching between code and spreadsheet to see what happened).

 

[nhulang]

****, that's going to take awhile. The person who created this put no notes, and it's a very cluttered. Lol!!

Thanks for the response!