| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| textBox font colour the same as cell font colour???????? | Excel Discussion (Misc queries) | |||
| How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
| how to colour a cell green if another cell is filled with text | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
