VBA SOURCE
CODE BOOK
Use this SIMPLE TRICK to
Highlight a Selected Row in
Microsoft Excel
DOWNLOAD VIEW
APPLICATION TRAINING
by: Randy Austin
ABOUT THE AUTHOR
A two-time Microsoft MVP & lifetime Excel enthusiast, Randy
Austin founded Excel For Freelancers in 2017. Excel For
Freelancers quickly became the most prominent resource Excel
for developers to learn how to turn their passion for Excel into
profits by building & selling their own excel-based applications
for passive & recurring income.
With nearly 300,000 YouTube subscribers, 14,000,000 video
views, 200+ comprehensive training videos, and a thriving 40,000
member Facebook community, Excel For Freelancers has
positioned itself as the #1 Excel developers resource in the world.
Get free content, training, and downloads just by clicking any of the free
resources below:
WEBSITE YOUTUBE FACEBOOK TWITTER
INSTAGRAM TELEGRAM RUMBLE
OUR COURSES &
PRODUCTS
This comprehensive program will take you through
a 12-phase process that will turn your enthusiasm
for Excel into passive income.
Click here to learn more
16 hour masterclass that will teach you the tips,
tricks and techniques on how to create a dynamic
single-click dashboard, and a ton more
Click here to learn more
Incredible Package of 175 of my BEST Applications
into a SINGLE ZIP File which also includes the "175
Workbook Library".
Click here to learn more
With 1000 live links, continuously updating content,
sort-able and filterable items, you will always have
exactly what you need, when you need it.
Click here to learn more
Table of Contents
Projects ..............................................................................................................................................................................................2
VBAProject .....................................................................................................................................................................................2
Documents ..................................................................................................................................................................................2
Sheet1......................................................................................................................................................................................2
(Declarations)........................................................................................................................................................................2
Worksheet_SelectionChange [Sub ] .....................................................................................................................................2
Sheet2......................................................................................................................................................................................4
(Declarations)........................................................................................................................................................................4
Sheet3......................................................................................................................................................................................6
(Declarations)........................................................................................................................................................................6
ThisWorkbook ..........................................................................................................................................................................8
(Declarations)........................................................................................................................................................................8
1 of 9
T
Sheet1 Highlight_Selected_Row.xlsm
1 Option Explicit
2
3 Private Sub Worksheet_SelectionChange(ByVal Target As Range)
4 If Not Intersect(Target, Range("E5:K14" )) Is Nothing Then
5 Range("A4" ).Value = [Link]
6 End If
7 End Sub
2 of 9
Index
E
Explicit, 2
I
Intersect, 2
R
Range, 2
Row, 2
T
Target, 2
V
Value, 2
W
Worksheet_SelectionChange, 2
3 of 9
Sheet2 Highlight_Selected_Row.xlsm
1 Option Explicit
2
4 of 9
Index
E
Explicit, 4
5 of 9
Sheet3 Highlight_Selected_Row.xlsm
1 Option Explicit
2
6 of 9
Index
E
Explicit, 6
7 of 9
ThisWorkbook Highlight_Selected_Row.xlsm
1 Option Explicit
2
8 of 9
Index
E
Explicit, 8
9 of 9
Thank You!
This source code was created and made available
to help you gain a better understanding of how
VBA is used to create amazing Excel-based
applications.
Thank you so much for your continued shares,
likes and support. It really helps.