Use VBA To Determine Hex Color Code

VBA Macro to Pull Hex Color Codes from Excel Cells

What This VBA Code Does

I ran into an issue where I needed some of my brand colors to be implemented on a web application. The only problem was the web application only accepted Hex color codes. While RGB color codes are readily available inside Excel (visible via the “More Colors…” option within the Color Palette), the Hex codes are not available to access within the Excel application. So here is a VBA macro solution that will quickly give you access to the Hex codes.

VBA Macro to Pull Hex Color Codes from Excel Cells

VBA Code:

This VBA macro code will loop through the user’s selected cells and write the hex color code for each fill color into the cell to the right.

Sub DetermineHexColor()
'PURPOSE: Display HEX Color Code to the right of each cell's Fill Color

Dim cell As Range
Dim FillHexColor As String

'Ensure a cell range is selected
  If TypeName(Selection) <> "Range" Then Exit Sub

'Loop through each cell in selection
  For Each cell In Selection.Cells
  
    'Ensure cell has a fill color
      If cell.Interior.ColorIndex <> xlNone Then
      
        'Get Hex values (values come through in reverse of what we need)
          FillHexColor = Right("000000" & Hex(cell.Interior.Color), 6)
        
        'Reverse the Hex code
          FillHexColor = Right(FillHexColor, 2) & Mid(FillHexColor, 3, 2) & Left(FillHexColor, 2)
        
        'Add # sign and display in cell to the right
          cell.Offset(0, 1).Value = "#" & FillHexColor
      
      End If
      
  Next cell

'Select just the ActiveCell
  ActiveCell.Select

End Sub

How Do I Modify This To Fit My Specific Needs?

Chances are this post did not give you the exact answer you were looking for. We all have different situations and it's impossible to account for every particular need one might have. That's why I want to share with you: My Guide to Getting the Solution to your Problems FAST! In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it

I highly recommend that you check this guide out before asking me or anyone else in the comments section to solve your specific problem. I can guarantee 9 times out of 10, one of my strategies will get you the answer(s) you are needing faster than it will take me to get back to you with a possible solution. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in (there never seem to be quite enough hours in the day!).

I wish you the best of luck and I hope this tutorial gets you heading in the right direction!

Chris
Founder, TheSpreadsheetGuru.com