pick color and use in excel

[fiep]

Hi,

I have a color picker for the user to select several colors for several types of data. (Which data is not interesting).
I get the color codes using the standard color picker. But when using the color code in a macro that exports data to excel:
.ActiveCell.Interior.ColorIndex = <code picked>

I get a runtime error. The color codes from the color picker are totally different from the codes in excel. Is there a way to convert this?

Thanks,

W.

 

[PHV]

And what about this ?
.ActiveCell.Interior.Color = <code picked>

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fiep]

Life can be so easy ;-)

Thanks very much.