Storing the Interior.ColorIndex number in a variable

[walkingaway]

Dear all,

I have a macro that would change:

• White cell to Red
• Red cell to White
• Any other coloured cell to Red

Please Login or Register  to view this content.

However, I would like to store the original colour of the cell, such that on the 1st double click, the cell becomes Red. On the 2nd double click, the cell changes back to the original colour.

Does anybody know how to achieve this? Any ideas will be greatly appreciated. Thanks!

[JBeaucaire]

Like so;

Please Login or Register  to view this content.

[walkingaway]

Dear Jerry,

Thanks for your help. The code works great. There however is a slight problem. After a cell (A1) has been coloured red via the macro, and I single click on another cell (B1), I am now unable to un-colour the cell (A1) by double-clicking on it. I believe this is due to the SelectionChange event being utilized here. Is there any way to bypass the SelectionChange event and build the macro solely in the Worksheet_BeforeDoubleClick event?

Thank you (:

[JBeaucaire]

Once you move on to another cell, it won't matter which event you're using, I don't think, they will all lose track of your previous colors unless you store ALL the colors of ALL the cells somewhere else for reference. The SelectionChange at least lets you color a cell red and immediately change it back.

[walkingaway]

Noted with thanks Jerry (: I will make do with this for now. Greatly appreciate your help.