Sub sdf()
s = 12775390
MsgBox h2d(s)
End Sub
Function h2d(aa)
bb = VBA.Hex(aa)
If Len(bb) < 3 Then
bb = "0000" & bb
ElseIf Len(bb) < 6 Then
bb = "00" & bb
End If
x3 = Left(bb, 2)
x3 = hex2dec(x3)
x2 = Mid(bb, 3, 2)
x2 = hex2dec(x2)
x1 = Right(bb, 2)
x1 = hex2dec(x1)
h2d = "红色" & x1 & "," & "绿色" & x2 & "," & "蓝色" & x3
End Function
颜色是由红绿蓝三色合成
12775390是十进制数,经过h2d函数转换成三种颜色的十进制数