troubleshooting Question

Excel VBA: Highlight Set Range When Cell Selected

Avatar of Dale James
Dale James asked on
VBAMicrosoft ExcelMicrosoft Office
9 Comments2 Solutions31 ViewsLast Modified:
Hello Team

Currently looking for a solution for the following:

Within a worksheet named "Summary" only, when a cell within column H is selected, for example, H5, the selected cell will then have the string "Priority" inserted and the current range will then resize to 0,-7 and have the selected cells having a colorindex 37 highlight. Also when the cell is selected again and if it already has the string value of "Priority", then both the value and the color highlight will be removed.

Thank you in advance.

Dale


ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros