Thanks Dave,

it works perfect for tracing changing values of variables!

However, I also like to trace defined names like [myName]. If I add the
control to the window, it stops on every line of my code. Is this not
possible?

Jos


"Dave Peterson" schreef in bericht
...
Inside the VBE:

Debug|Add watch

There's an option to "break when value changes"



Jos Vens wrote:

Hi,

does anyone know if it is possible to stop the VBA-code when it reaches
(the
first) variable I have in mind.

eg. I am tracing for a variable when it changes from value but I don't
know
anymore where it stands in my procedures, so I should like to ask excel
to
stop whenever it encounters this specific variable (in stead of setting
the
red dot in the margin or using the command Stop)

Thanks,
Jos Vens

--

Dave Peterson