Colour Picker

Hi,

I need a solution to either of these problems, both of which are similar in their outcome:

1. I have an active x colour picker (MMGUI.mjColorPicker) on my sheet. I need to be able to display the RGB values for the colour picked from the property window in cells in the sheet

2. I need a VBA colour picker that colours a specific cell AND also displays the RGB values in a cell.

I'd prefer an answer to 2. but in a pinch 1 would do.

Thanks
A

EggHeadCafe - Software Developer Portal of Choice
C# - Native SQL Provider Sample Speed Tests
http://www.eggheadcafe.com/tutorials...-provider.aspx