Event when a formula is recalculated?

[Gunti]

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

 

[Arvi Laanemets]

Hi

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

Arvi Laanemets

 

[Gunti]

Could you maybe create an example code with the following value's:

If Cell D32 is recalculated. Cell D33 should be 'x'

I read that the change event doesn't work on recalculating formula's by the
way. It only works on manual changes.

Grz and thanks,
Gunti