/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 vote315 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote342 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote383 views1 answer
Vba foreach 2d array
VBA
0 vote327 views1 answer
Excel vba delete folder
VBA
0 vote329 views1 answer
Vba horizontalalignment
VBA
18 votes484 views3 answers
Excel-vba make integer
VBA
0 vote352 views1 answer
Vba registry settings
VBA
0 vote339 views1 answer
How to get the value of optionbutton in vba
VBA
3 votes362 views1 answer
Vba post request json
VBA
5 votes353 views1 answer
Excel vba tool to help with refactoring code
VBA