Hi, my first post here.
I did write some seriously complex vba stuff years ago. There are about 50 forms, all with some kind of code and 5 modules with up to 50 scripts each.
Now I am faced with having to do some serious changes to my code, but my coding skills got a bit rusty.
I need to replace update sections of the code but first need to find all instances where a reference is made to a spreadsheet or a certain variable.
At the moment, I use ctrl+F, enter the search string and then press Next until I am through at least once, which is very time consuming...
=> Is there a way to FIND ALL instances of a string used in the CURRENT PROJECT?
Thanks, JR
I did write some seriously complex vba stuff years ago. There are about 50 forms, all with some kind of code and 5 modules with up to 50 scripts each.
Now I am faced with having to do some serious changes to my code, but my coding skills got a bit rusty.
I need to replace update sections of the code but first need to find all instances where a reference is made to a spreadsheet or a certain variable.
At the moment, I use ctrl+F, enter the search string and then press Next until I am through at least once, which is very time consuming...
=> Is there a way to FIND ALL instances of a string used in the CURRENT PROJECT?
Thanks, JR