Excel Tables are a great way to view and store all your important data, however viewing the row you have selected is not always obvious when quickly trying to get the information you need. That’s why anytime I create tables in my applications or for my customers, I always program in to Highlight the selected Row in Excel.
This simple programming task add professionalism and great a great user experience to any table in Excel. In the video below I demonstrate exactly how this is done in just a few short minutes
Just open up the Visual Basic Editor (Alt + F11) and place this code in any sheet. (Please make sure you change “E15:K14” to the actual range you want the highlight to appear.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("E5:K14")) Is Nothing Then Range("A4").Value = Target.Row End If End Sub
Please have a look and comment below and share your thoughts. Your Shares, Likes and Comments keep these training videos always FREE