Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting bkcolor on active cell when left mouse doubleclikked
Environment Office97 excel.
Hi, trying to set backgroundcolor of the cell which beeing doublecliked With Worksheets("Rodeuker").ActiveCell.Interior.Color = RGB(255, 0, 0) This doesnt work and I cant figure out, cause cant find anything in help-file for visual basic part of excel. Thank You regards jan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting bkcolor on active cell when left mouse doubleclikked
Did this with Macro Recorder:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End Sub "Jan Eikeland" wrote in message ... Environment Office97 excel. Hi, trying to set backgroundcolor of the cell which beeing doublecliked With Worksheets("Rodeuker").ActiveCell.Interior.Color = RGB(255, 0, 0) This doesnt work and I cant figure out, cause cant find anything in help-file for visual basic part of excel. Thank You regards jan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting bkcolor on active cell when left mouse doubleclikked
thanks , that worked, I must try the macro and watch the code comes out of
it. reg jan "JMay" skrev i melding news:SKhCb.2790$hf1.1368@lakeread06... Did this with Macro Recorder: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End Sub "Jan Eikeland" wrote in message ... Environment Office97 excel. Hi, trying to set backgroundcolor of the cell which beeing doublecliked With Worksheets("Rodeuker").ActiveCell.Interior.Color = RGB(255, 0, 0) This doesnt work and I cant figure out, cause cant find anything in help-file for visual basic part of excel. Thank You regards jan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting bkcolor on active cell when left mouse doubleclikked
Target provides a reference to the cell being doubleclicked. It would be
better to use that rather than depend on selection: Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Range, Cancel As Boolean) Target.ColorIndex = 3 ' or ' target.Interior.Color = RGB(255, 0, 0) End Sub -- Regards, Tom Ogilvy "Jan Eikeland" wrote in message ... thanks , that worked, I must try the macro and watch the code comes out of it. reg jan "JMay" skrev i melding news:SKhCb.2790$hf1.1368@lakeread06... Did this with Macro Recorder: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End Sub "Jan Eikeland" wrote in message ... Environment Office97 excel. Hi, trying to set backgroundcolor of the cell which beeing doublecliked With Worksheets("Rodeuker").ActiveCell.Interior.Color = RGB(255, 0, 0) This doesnt work and I cant figure out, cause cant find anything in help-file for visual basic part of excel. Thank You regards jan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my mouse won't scroll left or right in excel but will in other pr. | Excel Discussion (Misc queries) | |||
I click in a cell & it acts like I am holding onto the left mouse | Excel Discussion (Misc queries) | |||
How do I change mouse scroll from left and right to up and down? | New Users to Excel | |||
Mouse scroll jumps from up/down to left/right | Excel Discussion (Misc queries) | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) |