VBA code in debug - to pause/halt execution

[Fixador]

Hi All,

I'm sure i have seen this somewhere on this forum, but cant find it now .

I am trying track a variable , and pause execution when the variable gets to a declared value

I put into the Debug "Add Watch" the expression

Code: Select all

 RaceRows= 150

limited the scope to Sheet1 where it was active, then selected "Watch Type" to "watch expression" , and started the Cmd procedure

.........it never stopped at RaceRows=150, just ran through all the data

Have I misunderstood what "Watch" is ?

[Fixador]

further explain :-

I want the code to stop execution when RaceRows=150 - but, be able to examine the value of the other variables - by the yellow highlight gizmo - whilst at this stop point.

[KevinTHFC]

If you check the "Break when value is true" box the program will stop running when RaceRows = 150 and you can inspect the program variables.

Kevin