Hi

You have to choose between worksheet's Change and Calculate events.

Arvi Laanemets


"Gunti" wrote in message
...
Hi,
I'm learning to create some macro's, having some difficulties however.
I'll
sketch my situation.

I've got 6 checkboxes. I want an event to happen when i check or uncheck
any
of them. I also have a formula which depends on the checkboxes (like
if(A1=TRUE;"Yes";"No").

I need either an event to happen when the formula gets recalculated or
when
i uncheck or check any of the checkboxes.

Greets and Thanks,
Gunti