/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

15 votes280 views1 answer
Excel vba wait
VBA
0 vote258 views1 answer
Sort dictionary by key vba
VBA
0 vote241 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote239 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote263 views1 answer
Winforms dark title bar
VBA
0 vote254 views1 answer
Vba open report
VBA
0 vote226 views1 answer
Show unix time in vba
VBA
0 vote238 views1 answer
Vba get workbook name
VBA
0 vote244 views1 answer
Send text to clipboard vb.net
VBA
0 vote240 views1 answer
Openfiledialog specific folder
VBA