![]() |
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? |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com