VBA for Cell Color Counting

[wizardmagu]

I have some VBA code (very simple) to count cell color that I found on Youtube. I added the Worksheet and SelectionChange command to update my formula count of cells of a specific color. It seems to work for first few color changes, but then it stops working. I have to go into the formula and hit enter to get it to refresh. I am just curious is someone has any guidance on how to keep the command working.

 

[Joe4]

Read the section entitled "Color Change And Calculation" here: Color Functions In Excel

 

[wizardmagu]

I pasted that VBA code but keep getting an error. Do i need to change the code from your link to line up with names in my current VBA? This stuff is totally new to me

 

[Joe4]

There are a number of Count By Color codes out there that do the same thing. The point of my reply was not the code itself, but the explanation as to why your count doesn't update.
It is the nature of the beast. Formula are triggered/recalculated when values change, not formatting.

This is the explanation that I was referring to:

 

[wizardmagu]

I read through it to understand what was said. When I use format painter to paint cells to the target color it updates perfectly. I was just wondering if there was somthing out there that would allow it to update without the need to use format painter.

Thanks for the link

 

[Joe4]

There are other methods of counting by color. Admittedly, I have not tried them all out, so I cannot say which ones may work the way you want.
Here is a link with 6 such ways: 6 Ways to Count Colored Cells in Microsoft Excel [Illustrated Guide] | How To Excel