| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight row
Thanks....I so totally didn't notice that.
"Tom Ogilvy" wrote: The CHANGE event requires a change in the cell. The suggestion was to use the SELECTIONCHANGE event which does what you want. -- Regards, Tom Ogilvy "Jimbola" wrote in message ... This is close but it relies on a change being made to the cell for it to work. I want the row to be highlighted if you select it using the mouse or cursor keys -----Original Message----- If I read you correctly, you want to select the row for the cell being made active if that cell is in Column I. Try this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 9 Then Rows(Target.Row).Select End If End Sub tod -----Original Message----- Hi, I want an entire row to be highlighted (aka selected, as if clicking on the row number) if I click any cell in column I. I Know how to select a cell and how to highlight a row and how to use the worksheet change event. But not how to say highlight the row with the cell row number. Any help would be greatly appreciated. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Highlight every other row | Excel Discussion (Misc queries) | |||
| highlight row | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| highlight row | Excel Programming | |||
Hybrid Mode
