Avatar of Dale James
Dale James

asked on 

Excel VBA: Highlight Set Range When Cell Selected

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.


VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon