Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
I NEED TO HIGHLIGHT THE LINE THAT THE CURSOR IS ON AUTOMATICLY , SO AS I MOVE
THRU A LARGE SPREAD SHEET, I CAN CHECK ALL INFO ON THAT LINE. I DO NOT WANT TO HIGHLIGHT THE COLUMN. ANY IDEAS HOW TO DO THAT. TRY TO READ INFROMATION ON A LINE WHEN YOU HAVE 20 COLUMNS OF DATA ON 500 LINES. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
right click on the sheet tab and select view code
in the resulting module put in code like this: Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, _ ByVal Target As Excel.Range) rows.Interior.ColorIndex = xlNone Target.EntireRow.Interior.ColorIndex = 6 ' yellow - change as needed End Sub Note that if you try to paste a range, more than likely you won't be able to do it and you won't be able to undo as this will clear both the clipboard (of copied ranges) and the undo history. That is just a deleterious side effect. -- Regards, Tom Ogilvy "STAN" wrote: I NEED TO HIGHLIGHT THE LINE THAT THE CURSOR IS ON AUTOMATICLY , SO AS I MOVE THRU A LARGE SPREAD SHEET, I CAN CHECK ALL INFO ON THAT LINE. I DO NOT WANT TO HIGHLIGHT THE COLUMN. ANY IDEAS HOW TO DO THAT. TRY TO READ INFROMATION ON A LINE WHEN YOU HAVE 20 COLUMNS OF DATA ON 500 LINES. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
A non-code solution is to hit SHIFT-SPACE, that automatically selects the
whole row. CTRL-SPACE selects the whole column. "STAN" wrote: I NEED TO HIGHLIGHT THE LINE THAT THE CURSOR IS ON AUTOMATICLY , SO AS I MOVE THRU A LARGE SPREAD SHEET, I CAN CHECK ALL INFO ON THAT LINE. I DO NOT WANT TO HIGHLIGHT THE COLUMN. ANY IDEAS HOW TO DO THAT. TRY TO READ INFROMATION ON A LINE WHEN YOU HAVE 20 COLUMNS OF DATA ON 500 LINES. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
Thank you for your reply. I tried the view code ypui supplied and cannot get
it to operate. I am writing it just as I see it. Do I havea sytax error ? I have not used this function in the past so I cannot troubleshoot the proble. "Tom Ogilvy" wrote: right click on the sheet tab and select view code in the resulting module put in code like this: Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, _ ByVal Target As Excel.Range) rows.Interior.ColorIndex = xlNone Target.EntireRow.Interior.ColorIndex = 6 ' yellow - change as needed End Sub Note that if you try to paste a range, more than likely you won't be able to do it and you won't be able to undo as this will clear both the clipboard (of copied ranges) and the undo history. That is just a deleterious side effect. -- Regards, Tom Ogilvy "STAN" wrote: I NEED TO HIGHLIGHT THE LINE THAT THE CURSOR IS ON AUTOMATICLY , SO AS I MOVE THRU A LARGE SPREAD SHEET, I CAN CHECK ALL INFO ON THAT LINE. I DO NOT WANT TO HIGHLIGHT THE COLUMN. ANY IDEAS HOW TO DO THAT. TRY TO READ INFROMATION ON A LINE WHEN YOU HAVE 20 COLUMNS OF DATA ON 500 LINES. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
Tom.
I copied the file and pasted it to the spreadsheet and it worked great. Thank you for your solution. This option should still be made as a tool option. "Tom Ogilvy" wrote: right click on the sheet tab and select view code in the resulting module put in code like this: Private Sub Workbook_SheetSelectionChange( _ ByVal Sh As Object, _ ByVal Target As Excel.Range) rows.Interior.ColorIndex = xlNone Target.EntireRow.Interior.ColorIndex = 6 ' yellow - change as needed End Sub Note that if you try to paste a range, more than likely you won't be able to do it and you won't be able to undo as this will clear both the clipboard (of copied ranges) and the undo history. That is just a deleterious side effect. -- Regards, Tom Ogilvy "STAN" wrote: I NEED TO HIGHLIGHT THE LINE THAT THE CURSOR IS ON AUTOMATICLY , SO AS I MOVE THRU A LARGE SPREAD SHEET, I CAN CHECK ALL INFO ON THAT LINE. I DO NOT WANT TO HIGHLIGHT THE COLUMN. ANY IDEAS HOW TO DO THAT. TRY TO READ INFROMATION ON A LINE WHEN YOU HAVE 20 COLUMNS OF DATA ON 500 LINES. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight cursor row | Excel Discussion (Misc queries) | |||
auto comlete a row of data | New Users to Excel | |||
Vertical scroll bar jumps scrolls line 1 to line 2705? | Excel Worksheet Functions | |||
highlight cursor in Excel | Excel Discussion (Misc queries) | |||
change cursor to highlight cell I'm in | Excel Worksheet Functions |