Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
John Walkenbach Color Palette
I am using John Walkenbach Color Palette. I use it to colour a button on my
userform. I then use the passed color to search for text in my file that has the same color. The palatte comes up fine and passes the color to the button. Problem is, once the color is passed from the palette to the button the routine cannot seem to find the text with the same color eve though its clearly there. When I pick the color black in the palette, it illustrates the RGB color of: 0 0 206. This is the top left color (where the black would normally be). The code I have written to test if there is a match is: Public Function CellFontHasColour(rng As Range) If rng.Font.Color = FontColorColBtn.BackColor Then CellFontHasColour = True End If End Function In the immediate window I see: ?rng.Font.Color 0 ?FontColorColBtn.BackColor 12632256 Why is my back color denoted as 12632256? I thought I passed a RGB 0 0 206. Lastly, why is my color property on my font = 0? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring up Color Palette to select color | Excel Discussion (Misc queries) | |||
Changing text case in entire database column from JOHN to John | Excel Discussion (Misc queries) | |||
Color Palette, color disappears | Excel Discussion (Misc queries) | |||
how to format Doe,John to Doe, John (space after a comma) | Excel Worksheet Functions | |||
John Walkenbach Colour Palette | Excel Programming |