View Single Post
 
Old 10-29-2013, 01:53 PM
Ulodesk Ulodesk is offline Windows 7 64bit Office 2010 64bit
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 872
Ulodesk is on a distinguished road
Default Converting color codes in VBA

I have been unable to find an explanation of Word's (or VBA's, perhaps)7- or 8-digit color codes. Some references suggest a hexadecimal system, but what I see doesn't appear to match this.

For instance, an RGB 225/225/225 gray in hex is E1E1E1, but in VBA it appears as 'color pattern" 5131854. This is a macro used for filling selected table cells with color.

I would like to be able to change a color in a macro quickly without having to re-record the macro, but I would need an RGB converter, or at least a hex converter, to whatever this system is.

Can anyone point me in the right direction, please? Thanks.
Reply With Quote