E
ExcelMonkey
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?
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?