HEX/RGB color value to &H conversion

[AA Arens]

I know the HEX and RGB value of a code, but do not know the &H...
value. Anybode knows a converison tool on the web, or what is the VB
code. I want to fill it as color value for the backgroundcolor of a
command button.

Bart

 

[Paul B]

Bart, not sure but the addin here
http://www.andrewsexceltips.com/my_utilities.htm will make a sheet showing
the colors and Color Index ,HTML Colors, RGB Index, Color Name you may want
to give it a try and see if that is what you are looking for, when you
install it, look under other unities # 19


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Chip Pearson]

I'm not clear what you're after. What is the "H&" value you're looking for?
"&H" is used to indicate a hex value.

Dim L As Long
L = &HA
Debug.Print L 'display 10


If you want to get the hex representation of a number, use something like

Dim HexString As String
Dim L As Long
L = 255 * 256&
HexString = Hex(L)
' OR
HexString = "H&" & Hex(L)
Debug.Print HexString


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)