countcolor

[Pascal]

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

 

[Bob Phillips]

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)

 

[Bob Phillips]

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)