Hi, I'm using this Macro in VBA to get excel calculate every cell that
has a particular BG color in a determided range:

http://www.cpearson.com/excel/colors.htm
Counting Cells With A Specific Color

Does someone know how to modify this function so that it automatically
triggers a recalculation right after i modify a cell's bg color?
Because right now, I have to force it manually clicking on CTRL+ALT+F9.

Thanks a lot!

Pascal

Can't be done because changing a colour does not trigger any event that you
can tap into. You approach is one way, another is to create a colour toolbar
and set the colours by a macro from there, where you can force a
calculation.

But, no way to get it updated automatically.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pascal" wrote in message
oups.com...
Hi, I'm using this Macro in VBA to get excel calculate every cell that
has a particular BG color in a determided range:

http://www.cpearson.com/excel/colors.htm
Counting Cells With A Specific Color

Does someone know how to modify this function so that it automatically
triggers a recalculation right after i modify a cell's bg color?
Because right now, I have to force it manually clicking on CTRL+ALT+F9.

Thanks a lot!

Pascal