Change cell color on click

**oxicottin** · 01-01-2010, 12:33 AM

Hello, I have a grid of 22 X 22 squares that are white with a black border. Is there a way I can have a cell change to light yellow with a red border if clicked in and if clicked in again it would change back to white with black border. I needed to do this for several cells within the 22 X 22 cells. How can this be done?

Thanks,
Chad

**oxicottin** · 01-01-2010, 01:10 AM

Well I found the code below but I would also like to change the borders if I could... How could I do that? Thanks!

Please Login or Register  to view this content.

**teylyn** · 01-01-2010, 01:13 AM

Not knowing which Excel version you're using (please update your profile!), you can find out the code to set the border of a cell to red by switching on the macro recorder, formatt a cell's border to red, switch off the macro recorder and study the code generated.

hth

**rwgrietveld** · 01-01-2010, 03:38 AM

Simple addition to your code

Please Login or Register  to view this content.

**oxicottin** · 01-01-2010, 03:46 AM

Awesome just what I was looking for.... Thanks rwgrietveld!

**oxicottin** · 01-03-2010, 02:23 AM

rwgrietveld, I have another question. If I clicked on a square/cell how could I get it to color a 4 X 4 cell area "8 cells all together" with the cell that was clicked being the bottom left cell? Thanks!

I attached what I have so far.....