VBA Watches question -> how to get into break mode when value of x > 10,000?

[antaeusguy]

Hi guys

I've a variable x which is declared as Integer.

It changes value throughout the procedure.

When I run the procedure (F5), I want it to go into break mode when the value exceeds 10,000 (x > 10,000) so I can see which line causes it.

In the Add Watch, I choose "Break When Value is True". However, I don't know where to set the condition that x > 10,000...

I can't choose "Break When Value Changes" because it will go into break mode each time x changes value, which is not my intention..

Can someone here help me pls

 

[ISY]

Hello

If ciclo > 10000 :

If ciclo >10000 then
Doevents

Button Esc

 

[Norie]

You could try Debug.Assert.

Debug.Assert (x<10000)

This works the 'wrong' way round, it will break when the statement is False.