Excel 2007 : How to make a cell chnage it's background after every click?

Hi Friends,
I want an active cell to change it's background color every time it is clicked... For example, I would want cell (G9) to change it's color in following manner:
First Click... Green
Second Click... Red
Third Click... Some Pattern
4th Click... No formatting
5th Click... Green
.
.
.

and the sequence must repeat like this... I would be thankful if someone could help me on this...

You could try this. If you need the number of clicks to be saved when the workbook closes then you'd have to save a counter.

Please Login or Register  to view this content.

Use the macro recorder and get the exact pattern that you want to use and substitute it into the Select Case. You could also put this in the DoubleClick Event if you wanted to.

Please Login or Register  to view this content.

Thanks for your help mate