How To Highlight A Selected Row In An Excel Table

Randy Austin

Randy Austin

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

Download Your FREE Workbooks From either of the following links:
Using Your Email Here: http://bit.ly/HighlightRow_Wb
With Facebook Messenger Here: http://bit.ly/HighlightRow_FbDl

Get EARLY BIRD ACCESS To the upcoming Private Mentorship Program where we will be creating amazing applications on exclusive weekly videos & a monthly Live Webinar. Add your Name and Email here and I will let you know as soon as the program launches: http://bit.ly/MentorshipProgram_EarlyAccess

THIS WEEK’S PROMOTION: Get $50.00 OFF the Amazing Advanced Excel Dashboard Reports Masterclass using coupon Code “50OFF”. Enroll today before this promotion ends. http://bit.ly/masterclass_50OFF

💯 Get 100 Of My Best Workbooks in One Zip File Here: http://bit.ly/100_Excel_Workbooks_ZipFile

📗 The Ultimate Excel Resource Guide, with 1000 Excel Resources, is the last Excel resource you will ever need. See all of the details here: http://bit.ly/1000_Excel_Resources_Guide

Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook’s fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining

I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here:
Twitter: https://twitter.com/Excel4Freelance
LinkedIn: https://www.linkedin.com/in/excelforfreelancers/
Facebook: https://www.facebook.com/ExcelForFreelancers/

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on email