watch window

[g48dd]

Excel 2003: If you click on a formula in the formula bar, you can see what cells are involved, you can even step through it and watch it work to find problems. How can I do this with the VBA Editor?

Ken

 

[wigi]

Did you mean (in VBE):

View > Locals window
View > Watch window

 

[g48dd]

I think so, I am having a few problems with code either not working on pages it was written for or copy and paste stuff but it is wrong stuff probably because somewhere in the code it is no moving to correct sheet but I am not sure and that is why I wanted to know if I open the watch window can you see where the code is, can you sort of step through it? If so how?

Ken

 

[wigi]

Use F8 to step through the code. Use the suggested options, as well as hovering over the variables in the code line highlighted in yellow.