cell highlighting while scrolling with cursor

[zman1357]

I am trying to figure out how to scroll through a data set and have the row and column or just the row highlight as I am scrolling. I do not want to have to click to change rows. I have seen this on a few other sites but I cannot figure out how to complete this task. Any suggestions?

 

[Rick Rothstein]

Perhaps this event code will do what you want...

[table="width: 500"]
[tr]
	[td]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Static PriorTarget As Range
  If Not PriorTarget Is Nothing Then PriorTarget.EntireRow.Interior.ColorIndex = xlColorIndexNone
  Target.EntireRow.Interior.ColorIndex = 6
  Set PriorTarget = Target
End Sub[/td]
[/tr]
[/table]

HOW TO INSTALL Event Code
------------------------------------
If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

 

[Logit]

.
Found this resource which seems to perform as you indicated :

https://forums.windowssecrets.com/showthread.php/168376-code-to-highlight-Excel-row-upon-hover