| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of active row
I'm wondering if it's possible to have the row of the active cell highlighted
or shaded. As the user moves the cursor up or down, the active row will be shaded accordingly. Any suggestions? Thanks. -- Craig |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change color of active row
Hi Craig, Try this code. It shows both active Column, and Row. Make
sure the code is place in active worksheet event for "Worksheet_SelectionChange() " hth , Rick Private Sub Worksheet_SelectionChange(ByVal Target As Range) Rows.Interior.ColorIndex = 0 Target.EntireColumn.Interior.ColorIndex = 36 Target.EntireRow.Interior.ColorIndex = 36 End Sub "Craig" wrote in message ... I'm wondering if it's possible to have the row of the active cell highlighted or shaded. As the user moves the cursor up or down, the active row will be shaded accordingly. Any suggestions? Thanks. -- Craig |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change color of active row
Check this out...
http://www.cpearson.com/excel/excelM...ightActiveCell -- HTH... Jim Thomlinson "Craig" wrote: I'm wondering if it's possible to have the row of the active cell highlighted or shaded. As the user moves the cursor up or down, the active row will be shaded accordingly. Any suggestions? Thanks. -- Craig |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change color of active row
Thank you both for the suggestions!!
-- Craig "Craig" wrote: I'm wondering if it's possible to have the row of the active cell highlighted or shaded. As the user moves the cursor up or down, the active row will be shaded accordingly. Any suggestions? Thanks. -- Craig |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to i change the active cell highlight color? | Excel Discussion (Misc queries) | |||
| Change color of active cells | Excel Discussion (Misc queries) | |||
| Change color on active cell | Excel Programming | |||
| Active Row Column Color Change | Setting up and Configuration of Excel | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
