A very good question. The event code needs to remember the previous value of
some variable.

Declare a static variable in a standard module above any subs or functions
in that module. The event code can reference that variable and update its
value as necessary.
--
Gary''s Student
gsnu200710


"Curt" wrote:

useing event to trigger then after a code is run to come back and change
trigger value trigger. value is 10 want to change it to 10 after runnung
procedure. can we do this?
Thanks