/VBA/Excel vba highlight cells using the hex color value within the cells

Excel vba highlight cells using the hex color value within the cells

'VBA function to color cells in selected range based on the hex
'color number entered in each cell. For example, #FF69B4

Sub ColorCellsByHex()
    Dim r
    If TypeName(Selection) <> "Range" Then Exit Sub
    For Each r In Selection
        r.Interior.Color = Abs(("&H" & Mid(r, 6, 2) & Mid(r, 4, 2) & Mid(r, 2, 2)))
    Next
End Sub

Source: academy.excelhero.com

Similar codes

-1 vote134 views1 answer
For i in range vba
VBA
0 vote139 views1 answer
Limit combobox to list vba
VBA
2 votes142 views1 answer
Vba round number
VBA
1 vote141 views1 answer
How to put a gridpain in a vbox
VBA
0 vote173 views1 answer
Vb ternary
VBA
0 vote134 views1 answer
Vba border weight
VBA
0 vote134 views1 answer
Vba string
VBA
2 votes131 views2 answers
Excel vba copy values range to another range
VBA
0 vote133 views1 answer
Vba like with wildcard
VBA
18 votes273 views3 answers
Excel-vba make integer
VBA