Cell colour

[gav meredith]

Hello,

Is there a way i can use a click event or double-click event to change a
cell colour to red (not the content, the actual cell background) and have it
change back to white when actioned again??

Thanks!!!!

 

[Vasant Nanavati]

Didn't we cover this just yesterday???

 

[gav meredith]

and you didnt get back to me with how to create with a double click event??

 

[Vasant Nanavati]

and you didnt get back to me with how to create with a double click event??

I certainly did. Then you responded saying that you wanted the cell
background, rather than the font, to change color. And Bob Phillips
responded to you showing you how to amend my code to do just that.

 

[gav meredith]

my deepest apologies to you vasant and bob also. I missed it completely.

did you see my other post regarding the copy/paste function (alter existing
code). This relates directly and i am hoping to be able to amend my code??

Again, thank you very much!!

 

[Guest]

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean
If Target.Interior.ColorIndex = xlNone The
Target.Interior.ColorIndex =
ElseIf Target.Interior.ColorIndex = 3 The
Target.Interior.ColorIndex = xlNon
End I
End Sub

 

[Vasant Nanavati]

Gav, I'm not going to have the time to look at it tonight as it seems
somewhat involved and I don't have a stretch of time to review it in detail.
Perhaps someone else can jump in, or you may want to repost it.

 

[gav meredith]

thats fine , i really appreciate your help. I will repost it!!

Thank you!!