Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Is there any way to get colours to the row and to the column where the cursor is. They should change every time when moving the cursor. Thanks! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Right click sheet tabview code insert this
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Cells.Interior.ColorIndex = 0 With ActiveCell .EntireRow.Interior.ColorIndex = 36 .EntireColumn.Interior.ColorIndex = 36 End With End Sub -- Don Guillett SalesAid Software "Reedhill" wrote in message ... Hi Is there any way to get colours to the row and to the column where the cursor is. They should change every time when moving the cursor. Thanks! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() you may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm Reedhill wrote: Hi Is there any way to get colours to the row and to the column where the cursor is. They should change every time when moving the cursor. Thanks! -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks both of you. They worked fine.
"Reedhill" kirjoitti: Hi Is there any way to get colours to the row and to the column where the cursor is. They should change every time when moving the cursor. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can't I CONSISTENTLYmove cursor from first column to last colu | Excel Discussion (Misc queries) | |||
Highlights/changes the column and row appearance as the cursor mov | Excel Discussion (Misc queries) | |||
can I have the cursor go to same row/column in each sheet | Excel Discussion (Misc queries) | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
Why is my tab key moving my cursor from column A to column k? | Excel Discussion (Misc queries) |