I have code that changes a cell fill to yellow when clicked... and back to blank when clicked again. This works fine.
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 usingPlease Login or Register to view this content.
and this works... but I want it to work at each cell click within F3:F5.Please Login or Register to view this content.
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
Bookmarks