/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

0 vote172 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote165 views1 answer
Vba simple quote
VBA
0 vote175 views1 answer
Excel vba protect shapes
VBA
1 vote168 views1 answer
How to remove zeros in excel
VBA
0 vote193 views1 answer
Vbnet add axis labels to chart
VBA
0 vote162 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote163 views1 answer
Arq linux
VBA
0 vote160 views1 answer
Add text to combobox drop down vb
VBA
0 vote166 views1 answer
Vba copy file
VBA
-1 vote152 views1 answer
VBA check if a cell contains a letter or string
VBA