Backcolor value in hex

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

I want to get the hex value of a cell's backcolor, so I can replicate
the same color in Access. In VBA, I try to derive this by using
Hex(sheet.range(cell).interior.color). I get a hex value, but when I
try it in Access, it displays a different color. Am I grabbing the
correct property from the cell in Excel? Or, is there another way I can
derive the hex value?

Thanks in advance.
 
What version of Excel/Access are you using 2003 or 2007?

I'm believe you can set the color using HSL or RGB scales, which apply to
both Excel and Access (at least in 2003).
 
Back
Top