Event when a formula is recalculated?

  • Thread starter Thread starter Gunti
  • Start date Start date
G

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
 
Hi

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

Arvi Laanemets
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does Excel recalculate when I make a different filter selectio 2
Macro + IF Function? 1
Recalculate Formula when field value changes 1
PivotCharts and recalculating workbooks 1
Recalculation of formulae disabled 2
Recalculate changes only 2
whole workbook recalculates when I change a cell 3
Disabling formula recalculation when opening or closing workbooks 3

Back
Top