Cell colour
 

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

Cell colour
 

Didn't we cover this just yesterday???

--

Vasant

"gav meredith" wrote in message
...
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!!!!

Cell colour
 

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

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Didn't we cover this just yesterday???

--

Vasant

"gav meredith" wrote in message
...
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!!!!

Cell colour
 

"gav meredith" wrote in message
...
and you didnt get back to me with how to create with a double click
event??

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Didn't we cover this just yesterday???


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.

--

Vasant

Cell colour
 

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

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
"gav meredith" wrote in message
...
and you didnt get back to me with how to create with a double click
event??

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Didn't we cover this just yesterday???


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.

--

Vasant

Cell colour
 

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

Cell colour
 

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.

--

Vasant

"gav meredith" wrote in message
...
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!!

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
"gav meredith" wrote in message
...
and you didnt get back to me with how to create with a double click
event??

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Didn't we cover this just yesterday???


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.

--

Vasant