'Have watches set automatically in VBA editor [duplicate]
I've been learning all the nifty tools I have to debug in the VBA editor for excel, but I can't figure out if there's a way to have watches stay set for a project even if its closed/reopened until I remove them. Im doing a lot of stepping-in, etc. while Im learning, and while having watches really helps, its annoying that every time I close/open a file, I have to reset all the watches. This is really annoying when I have several variables I want to keep track of while debugging, say, a Workbook_Open event and I'm closing/opening a lot!
Is there a way to turn on watches for a module or project so they come back on when the project is closed and re-opened? Or do I have to set them manually every...single...time...?
Solution 1:[1]
I have a similar requirement.
My proposal was "print" variables in columns in new sheet [with name LOG]. I can save values / times and result and shared that with my team.
Steps:
- Define breakpoints
- Insert new line in LOG sheet
- Save Values and date time
- Compare results
Regards
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Carlos J. |