/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 vote235 views1 answer
Visual basic cmd
VBA
0 vote207 views1 answer
Vba sheet visible
VBA
0 vote218 views1 answer
Vba dictionary clear
VBA
0 vote222 views1 answer
Selecttoken em vbnet e json
VBA
0 vote199 views1 answer
Refresh token em vb net
VBA
0 vote202 views1 answer
Vba file size
VBA
0 vote214 views1 answer
How to format a textbox as date vb net
VBA
0 vote226 views1 answer
Vba search string position
VBA
0 vote216 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote201 views1 answer
Replace spaces with underscores vbnet
VBA