SumByColor with cell click

[Excellentt]

I have code that changes a cell fill to yellow when clicked... and back to blank when clicked again. This works fine.

Please Login or Register  to view this content.

I'm using a UDF to sum cells by color with this, and this too works fine.

Please Login or Register  to view this content.

Finally, I'm using

Please Login or Register  to view this content.

and this works... but I want it to work at each cell click within F3:F5.

How do I make this formula fire when clicking in cell F3:F5? Seems like it should do it but I can't make it work. The only way it will work is if I click in the cell with the formula and hit enter.

I believe I need a selection change event. Am I correct?

Thanks for all you guys much smarter at this than I am. See attached picture.

Excel1.png

[mikerickson]

Changing a cell's color doesn't trigger Calculation. You could explicitly call calculation at the end of the Double Click event.

Please Login or Register  to view this content.

[Excellentt]

Sorry. It didn't work.

[mikerickson]

Have you tried it combined with making the UDF volatile?

[humdingaling]

you can add

Please Login or Register  to view this content.

to the UDF to make it reactive

[Excellentt]

Thanks guys! You nailed it. Works perfectly!