Event when a formula is recalculated?
 

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

Event when a formula is recalculated?
 

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

Event when a formula is recalculated?
 

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

"Arvi Laanemets" wrote:

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