mattrix
12-11-2012, 06:27 PM
Hi,
I have a VBA LOOP that processes a sheet and writes a result.
Unfortunately there seem to be more exceptions than rules.
At the moment I've got a breakpoint at the end of the loop which works but requires lots of clicks per loop:
* The break-point takes me to the VBA window
* then I go to the excel window
* check result and make any changes required
* go back to the VBA window
* F5 to continue
what i'd like is to avoid the VBA window altogether, use VBA to pause execution at the end of each loop, so that I can see the result on the sheet and press a key on the keyboard to loop and calculate the next result; and still be able to make changes to the sheet if necessary.
Any ideas on how I might do this?
I have a VBA LOOP that processes a sheet and writes a result.
Unfortunately there seem to be more exceptions than rules.
At the moment I've got a breakpoint at the end of the loop which works but requires lots of clicks per loop:
* The break-point takes me to the VBA window
* then I go to the excel window
* check result and make any changes required
* go back to the VBA window
* F5 to continue
what i'd like is to avoid the VBA window altogether, use VBA to pause execution at the end of each loop, so that I can see the result on the sheet and press a key on the keyboard to loop and calculate the next result; and still be able to make changes to the sheet if necessary.
Any ideas on how I might do this?