/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 vote153 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote138 views1 answer
Vba string
VBA
8 votes259 views1 answer
Vba convert 2 bytes to an integer
VBA
1 vote142 views1 answer
Excel vba close form escape key
VBA
0 vote143 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote134 views1 answer
Vba file size
VBA
0 vote139 views1 answer
Visual basic msdos
VBA
1 vote153 views1 answer
Excel vba last row of range
VBA
1 vote151 views1 answer
Excel vba array remove first
VBA
0 vote156 views4 answers
Vgrive,deb
VBA