I'm attempting to create a userform for a workbook, and I have a very specific color palette I am to use (company standard colors), which is fine, but I cannot seem to figure out how Excel is setting the BackColor property.
For example: the default grey setting for a userform uses &H8000000F&. I read somewhere that if you use the for &H00......&, you can use a Hex value where the dots are -- unfortunately, this results in the wrong colors. For example a dark blue (RGB 26-39-50, Hex 1a2732) returns a dark brownish color when using the value &H001a2732&.
Any thoughts?
For example: the default grey setting for a userform uses &H8000000F&. I read somewhere that if you use the for &H00......&, you can use a Hex value where the dots are -- unfortunately, this results in the wrong colors. For example a dark blue (RGB 26-39-50, Hex 1a2732) returns a dark brownish color when using the value &H001a2732&.
Any thoughts?