Hi,

Is there a way to start a procedure when a cells' value switch between
false/true... without Worksheet_Calculate event?!
There should be like a little "agent" looking at the cell (or the checkbox
object) and every time it take False or True, a procedure can run.

Worksheet_Change event is not either a solution, the target of action isn't
that cell but a checkbox object, initiating the cell to set false or true
value. Can you start a procedure through a contitional format function
somehow, manybe?

Now, I actually use Worksheet_Calculate event, but it doesn't work so good,
because it seems like every time I make a change in any cell at all in the
worksheet and start a worksheet_change event, the worksheet_calculate
procedure seem to occure as well (Yes, I use the Application.EnableEvents =
False). I can't understand why it does, I try to find the solution this way
as well right know.

I found some about recalculation in
http://www.decisionmodels.com/calcsecrets.htm, but havn't been able to
change it into code...



/
Kind Regards