十六进制、RGB 与 VBA颜色值对照表

ゝ一纸荒年。 2022-08-30 14:59 2365阅读 0赞

![在这里插入图片描述][fb5914c6b5d458903a2c1fb93bc1dddf.gif_pic_center]

### 十六进制、RGB 与 VBA颜色值对照表 ###

<table> 
 <tbody> 
 <tr> 
 <th>颜色名称 </th> 
 <th>RGB颜色 </th> 
 <th>十六进制颜色代码 </th> 
 <th>VBA颜色代码 </th> 
 <th>颜色效果 </th> 
 </tr> 
 <tr> 
 <td>黑色</td> 
 <td>0,0,0</td> 
 <td>#000000</td> 
 <td>&amp;H000000</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>象牙黑</td> 
 <td>41,36,33</td> 
 <td>#292421</td> 
 <td>&amp;H212429</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>灰色</td> 
 <td>192,192,192</td> 
 <td>#C0C0C0</td> 
 <td>&amp;HC0C0C0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>冷灰</td> 
 <td>128,138,135</td> 
 <td>#808A87</td> 
 <td>&amp;H878A80</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>石板灰</td> 
 <td>112,128,105</td> 
 <td>#708069</td> 
 <td>&amp;H698070</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>暖灰色</td> 
 <td>128,128,105</td> 
 <td>#808069</td> 
 <td>&amp;H698080</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>白色</td> 
 <td>225,225,225</td> 
 <td>#FFFFFF</td> 
 <td>&amp;HFFFFFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>古董白</td> 
 <td>250,235,215</td> 
 <td>#FAEBD7</td> 
 <td>&amp;HD7EBFA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>天蓝色</td> 
 <td>240,255,255</td> 
 <td>#F0FFFF</td> 
 <td>&amp;HFFFFF0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>白烟</td> 
 <td>245,245,245</td> 
 <td>#F5F5F5</td> 
 <td>&amp;HF5F5F5</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>白杏仁</td> 
 <td>255,235,205</td> 
 <td>#FFFFCD</td> 
 <td>&amp;HCDFFFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>米绸色</td> 
 <td>255,248,220</td> 
 <td>#FFF8DC</td> 
 <td>&amp;HDCF8FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>蛋壳色</td> 
 <td>252,230,201</td> 
 <td>#FCE6C9</td> 
 <td>&amp;HC9E6FC</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>花白</td> 
 <td>255,250,240</td> 
 <td>#FFFAF0</td> 
 <td>&amp;HF0FAFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>浅灰色</td> 
 <td>220,220,220</td> 
 <td>#DCDCDC</td> 
 <td>&amp;HDCDCDC</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>幽灵白色</td> 
 <td>248,248,255</td> 
 <td>#F8F8FF</td> 
 <td>&amp;HFFF8F8</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>蜜露橙</td> 
 <td>240,255,240</td> 
 <td>#F0FFF0</td> 
 <td>&amp;HF0FFF0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>象牙白</td> 
 <td>250,255,240</td> 
 <td>#FAFFF0</td> 
 <td>&amp;HF0FFFA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>亚麻色</td> 
 <td>250,240,230</td> 
 <td>#FAF0E6</td> 
 <td>&amp;HE6F0FA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>耐而节白</td> 
 <td>255,222,173</td> 
 <td>#FFDEAD</td> 
 <td>&amp;HADDEFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>象牙色</td> 
 <td>253,245,230</td> 
 <td>#FDF5E6</td> 
 <td>&amp;HE6F5FD</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>海贝壳色</td> 
 <td>255,245,238</td> 
 <td>#FFF5EE</td> 
 <td>&amp;HEEF5FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>雪白</td> 
 <td>255,250,250</td> 
 <td>#FFFAFA</td> 
 <td>&amp;HFAFAFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>红色</td> 
 <td>255,0,0</td> 
 <td>#FF0000</td> 
 <td>&amp;H0000FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>砖红</td> 
 <td>156,102,31</td> 
 <td>#9C661F</td> 
 <td>&amp;H1F669C</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>镉红</td> 
 <td>227,23,13</td> 
 <td>#E3170D</td> 
 <td>&amp;H0D17E3</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>珊瑚色</td> 
 <td>255,127,80</td> 
 <td>#FF7F50</td> 
 <td>&amp;H507FFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>耐火砖红</td> 
 <td>178,34,34</td> 
 <td>#B22222</td> 
 <td>&amp;H2222B2</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>印度红</td> 
 <td>176,23,31</td> 
 <td>#B0171F</td> 
 <td>&amp;H1F17B0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>栗色</td> 
 <td>176,48,96</td> 
 <td>#B03060</td> 
 <td>&amp;H6030B0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>粉红</td> 
 <td>255,192,203</td> 
 <td>#FFC0CB</td> 
 <td>&amp;HCBC0FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>草莓色</td> 
 <td>135,38,87</td> 
 <td>#872657</td> 
 <td>&amp;H572687</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>橙红色</td> 
 <td>250,128,114</td> 
 <td>#FA8072</td> 
 <td>&amp;H7280FA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>蕃茄红</td> 
 <td>255,99,71</td> 
 <td>#FF6347</td> 
 <td>&amp;H4763FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>桔红</td> 
 <td>255,69,0</td> 
 <td>#FF4500</td> 
 <td>&amp;H0045FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>深红色</td> 
 <td>255,0,255</td> 
 <td>#FF00FF</td> 
 <td>&amp;HFF00FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>黄色</td> 
 <td>255,255,0</td> 
 <td>#FFFF00</td> 
 <td>&amp;H00FFFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>香蕉色</td> 
 <td>227,207,87</td> 
 <td>#E3CF57</td> 
 <td>&amp;H57CFE3</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>镉黄</td> 
 <td>255,153,18</td> 
 <td>#FF9912</td> 
 <td>&amp;H1299FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>dougello</td> 
 <td>235,142,85</td> 
 <td>#EB8E55</td> 
 <td>&amp;H558EEB</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>forum go</td> 
 <td>255,227,132</td> 
 <td>#FFE384</td> 
 <td>&amp;H84E3FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>金黄色</td> 
 <td>255,215,0</td> 
 <td>#FFD700</td> 
 <td>&amp;H00D7FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>黄花色</td> 
 <td>218,165,105</td> 
 <td>#DAA569</td> 
 <td>&amp;H69A5DA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>瓜色</td> 
 <td>227,168,105</td> 
 <td>#E3A869</td> 
 <td>&amp;H69A8E3</td> 
 <td>&gt;</td> 
 </tr> 
 <tr> 
 <td>橙色</td> 
 <td>255,97,0</td> 
 <td>#FF6100</td> 
 <td>&amp;H0061FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>镉橙</td> 
 <td>255,97,3</td> 
 <td>#FF6103</td> 
 <td>&amp;H0361FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>胡萝卜色</td> 
 <td>237,145,33</td> 
 <td>#ED9121</td> 
 <td>&amp;H2191ED</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>桔黄</td> 
 <td>255,128,0</td> 
 <td>#FF8000</td> 
 <td>&amp;H0080FF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>淡黄色</td> 
 <td>245,222,179</td> 
 <td>#F5DEB3</td> 
 <td>&amp;HB3DEF5</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>棕色</td> 
 <td>128,42,42</td> 
 <td>#802A2A</td> 
 <td>&amp;H2A2A80</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>米色</td> 
 <td>163,148,128</td> 
 <td>#A39480</td> 
 <td>&amp;H8094A3</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>锻浓黄土色</td> 
 <td>138,54,15</td> 
 <td>#8A360F</td> 
 <td>&amp;H0F368A</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>锻棕土色</td> 
 <td>135,51,36</td> 
 <td>#873324</td> 
 <td>&amp;H243387</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>巧克力色</td> 
 <td>210,105,30</td> 
 <td>#D2691E</td> 
 <td>&amp;H1E69D2</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>肉色</td> 
 <td>255,125,64</td> 
 <td>#FF7D40</td> 
 <td>&amp;H407DFF</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>黄褐色</td> 
 <td>240,230,140</td> 
 <td>#F0E68C</td> 
 <td>&amp;H8CE6F0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>玫瑰红</td> 
 <td>188,143,143</td> 
 <td>#BC8F8F</td> 
 <td>&amp;H8F8FBC</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>肖贡土色</td> 
 <td>199,97,20</td> 
 <td>#C76114</td> 
 <td>&amp;H1461C7</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>标土棕</td> 
 <td>115,74,18</td> 
 <td>#734A12</td> 
 <td>&amp;H124A73</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>乌贼墨棕</td> 
 <td>94,38,18</td> 
 <td>#5E2612</td> 
 <td>&amp;H12265E</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>赫色</td> 
 <td>160,82,45</td> 
 <td>#A0522D</td> 
 <td>&amp;H2D52A0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>马棕色</td> 
 <td>139,69,19</td> 
 <td>#8B4513</td> 
 <td>&amp;H13458B</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>沙棕色</td> 
 <td>244,164,96</td> 
 <td>#F4A460</td> 
 <td>&amp;H60A4F4</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>棕褐色</td> 
 <td>210,180,140</td> 
 <td>#D2B48C</td> 
 <td>&amp;H8CB4D2</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>蓝色</td> 
 <td>0,0,255</td> 
 <td>#0000FF</td> 
 <td>&amp;HFF0000</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>钴色</td> 
 <td>61,89,171</td> 
 <td>#3D59AB</td> 
 <td>&amp;HAB593D</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>道奇蓝</td> 
 <td>30,144,255</td> 
 <td>#1E90FF</td> 
 <td>&amp;HFF901E</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>Jackie blue</td> 
 <td>11,23,70</td> 
 <td>#0B1746</td> 
 <td>&amp;H46170B</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>锰蓝</td> 
 <td>3,168,158</td> 
 <td>#03A89E</td> 
 <td>&amp;H9EA803</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>深蓝色</td> 
 <td>25,25,112</td> 
 <td>#191970</td> 
 <td>&amp;H701919</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>孔雀蓝</td> 
 <td>51,161,201</td> 
 <td>#33A1C9</td> 
 <td>&amp;HC9A133</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>土耳其玉色</td> 
 <td>0,199,140</td> 
 <td>#00C78C</td> 
 <td>&amp;H8CC700</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>浅灰蓝色</td> 
 <td>176,224,230</td> 
 <td>#B0E0E6</td> 
 <td>&amp;HE6E0B0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>品蓝</td> 
 <td>65,105,225</td> 
 <td>#4169E1</td> 
 <td>&amp;HE16941</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>石板蓝</td> 
 <td>106,90,205</td> 
 <td>#6A5ACD</td> 
 <td>&amp;HCD5A6A</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>天蓝</td> 
 <td>135,206,235</td> 
 <td>#87CEEB</td> 
 <td>&amp;HEBCE87</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>青色</td> 
 <td>0,255,255</td> 
 <td>#00FFFF</td> 
 <td>&amp;HFFFF00</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>绿土</td> 
 <td>56,94,15</td> 
 <td>#385E0F</td> 
 <td>&amp;H0F5E38</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>靛青</td> 
 <td>8,46,84</td> 
 <td>#082E54</td> 
 <td>&amp;H542E08</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>碧绿色</td> 
 <td>127,255,212</td> 
 <td>#7FFFD4</td> 
 <td>&amp;HD4FF7F</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>青绿色</td> 
 <td>64,224,208</td> 
 <td>#40E0D0</td> 
 <td>&amp;HD0E040</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>绿色</td> 
 <td>0,255,0</td> 
 <td>#00FF00</td> 
 <td>&amp;H00FF00</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>黄绿色</td> 
 <td>127,255,0</td> 
 <td>#7FFF00</td> 
 <td>&amp;H00FF7F</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>钴绿色</td> 
 <td>61,145,64</td> 
 <td>#3D9140</td> 
 <td>&amp;H40913D</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>翠绿色</td> 
 <td>0,201,87</td> 
 <td>#00C957</td> 
 <td>&amp;H57C900</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>森林绿</td> 
 <td>34,139,34</td> 
 <td>#228B22</td> 
 <td>&amp;H228B22</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>草地绿</td> 
 <td>124,252,0</td> 
 <td>#7CFC00</td> 
 <td>&amp;H00FC7C</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>酸橙绿</td> 
 <td>50,205,50</td> 
 <td>#32CD32</td> 
 <td>&amp;H32CD32</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>薄荷色</td> 
 <td>189,252,201</td> 
 <td>#BDFCC9</td> 
 <td>&amp;HC9FCBD</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>草绿色</td> 
 <td>107,142,35</td> 
 <td>#6B8E23</td> 
 <td>&amp;H238E6B</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>暗绿色</td> 
 <td>48,128,20</td> 
 <td>#308014</td> 
 <td>&amp;H148030</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>海绿色</td> 
 <td>46,139,87</td> 
 <td>#2E8B57</td> 
 <td>&amp;H578B2E</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>嫩绿色</td> 
 <td>0,255,127</td> 
 <td>#00FF7F</td> 
 <td>&amp;H7FFF00</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>紫色</td> 
 <td>160,32,240</td> 
 <td>#A020F0</td> 
 <td>&amp;HF020A0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>紫罗蓝色</td> 
 <td>138,43,226</td> 
 <td>#8A2BE2</td> 
 <td>&amp;HE22B8A</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>jasoa</td> 
 <td>160,102,211</td> 
 <td>#A066D3</td> 
 <td>&amp;HD366A0</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>湖紫色</td> 
 <td>153,51,250</td> 
 <td>#9933FA</td> 
 <td>&amp;HFA3399</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>淡紫色</td> 
 <td>218,112,214</td> 
 <td>#DA70D6</td> 
 <td>&amp;HD670DA</td> 
 <td></td> 
 </tr> 
 <tr> 
 <td>梅红色</td> 
 <td>221,160,221</td> 
 <td>#DDA0DD</td> 
 <td>&amp;HDDA0DD</td> 
 <td></td> 
 </tr> 
 </tbody> 
</table>

# 2. 颜色转换函数 #

## 2.1 VBA颜色转 RGB ##

Public Function VB2RGB(Color As Long) As String
        Const ByN As Integer = 256
        Const ByN2 As Long = 65536
        Dim A(2) As Byte
        A(0) = (Color Mod ByN)
        A(1) = ((Color Mod ByN2) \ ByN)
        A(2) = (Color \ ByN2)
        VB2RGB = A(0) & "," & A(1) & "," & A(2)
    End Function

调用：

Sub test()
    	MsgBox VB2RGB(16777215)  '返回 255,255,255
    End Sub

## 2.2 十六进制颜色值 ##

**VBA中的颜色表示法**

格式： &HBBGGRR&  
说明：BB、GG、RR分别为两位十六进制数，表示蓝、绿、红色的亮度，其值为 `00 ~ FF`,中间值为`80`。

例如：`&HFF0000&`为亮蓝色，`&H00FFFF&`（也可写为`&HFFFF&`）为黄色。

![在这里插入图片描述][d181b1e6f5fa19989a6f157f292ebe13.gif_pic_center]

[fb5914c6b5d458903a2c1fb93bc1dddf.gif_pic_center]: /images/20220829/eef4dcd89741492c9ad4edfbb7096b1d.png
[d181b1e6f5fa19989a6f157f292ebe13.gif_pic_center]: /images/20220829/e8be97b2f8074f88b115eb8723513b55.png