Cell colour

G

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!!!!
 
V

Vasant Nanavati

gav meredith said:
and you didnt get back to me with how to create with a double click event??
Click to expand...

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.
 
G

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!!
 
C

chris

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
 
V

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.
 
Top