AnsweredAssumed Answered

vrf Load a color index from excel

Question asked by VRFuser on Apr 3, 2003
Blohm (really??

> I need the color palette to select
> the color and with the color the index
> of the color.

Yeowza! Well, it looks to me like the color picker is basically the common
color dialog so just use that (ActiveX Control References, check Microsoft
Common Dialog Control [NOTE: *NOT* Microsoft Windows Common Controls], place
control, call ShowColor). I don't see any "special" Excel color values so
it's probably ... hmmm... it says there's a Color and a ColorIndex property
on the Border object. And they're both Variant. That's bad, they should be
OleColor. So, hopefully you won't have to convert a color from the color
picker to an "xlColor" value.

You are currently subscribed to vrf as:
To subscribe send a blank email to "".
To unsubscribe send a blank email to "".
To send messages to this mailing list,  email "". 
If you need help with the mailing list send a message to "".