Highlight all appearances of a particular variable used

[Tejas Kore]

Hi Friends,

I have used one variable in my code , let's say x_arr.
Now I have used this variable n number of times in my vba code.But now for some reason I need to change the name of this variable. Since I have used this variable n number of times , I have to make n number of changes.
Is there any way to highlight all the appearances of the variable so that my job gets easier.

 

[TonyUK72]

Yes of course, VBA Editor has the find/replace option of most MS applications. As this will be your fist time using it, I would copy ALL of your offending code into notepad. Use replace ALL in notepad and check that it has successfully worked. You will then be able to paste the new code back into the module.

 

[Tejas Kore]

Hi TonyUK72,

Thanks a lot for your proactive approach.
I just wanted to clarify further.
Do we have such option in VB Editor itself ? Or we have to copy code to notepad , make necessary changes , and then again copy back to module ?

 

[Tejas Kore]

Thanks a lot TonyUK72 for guiding me.
It was really helpful.I searched in VB Editor and managed to do that.

Once again .. Thanks a lot

 

[TonyUK72]

"Ctrl + H" within the VBA Editor, I recommended notepad as if the expression you want to replace is referenced (or is even part off) it will also be replaced!!!!

 

[Tejas Kore]

Oh My God !!! .. I didn't realised that in your first reply.
I will keep that in mind while doing such operations.