/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 vote157 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote163 views1 answer
Vb net check if file exists
VBA
5 votes197 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote130 views1 answer
How to sort datagridview in vb.net
VBA
0 vote169 views1 answer
Vbnet find highest value in chart
VBA
1 vote185 views1 answer
Extract the second word in a text in excel
VBA
3 votes212 views1 answer
Vba post request json
VBA
0 vote195 views1 answer
Vbscript remove spaces from string
VBA
4 votes186 views2 answers
Vba create folder if not exist
VBA
6 votes173 views1 answer
Excel vba check if a string only contains letters
VBA