Hi
in the VBE Editor just define a watch for this variable

--
Regards
Frank Kabel
Frankfurt, Germany

Stewart1234 wrote:
How do I watch a variable in an excel macro change value as the
visual basic code is running? The variable changes value every 30
seconds or so and I want to monitor progress of the execution by
looking at the value without stopping the run.