Hi,
Objective
*******
I'm developing an utility where the user is given a option to select
color. Then certain cells in the excel will be filled with that color
I have a user form where the user chooses the color. I'm usin
CommonDialog.ShowColor to show the dialog.

Problem
******
CommonDialog.Color returns a long. And
Cell1.Interior.ColorIndex=CommonDialog.Color throws an error. I thin
this is due to the fact that ColorIndex can take values on upto 5
only.

Is there a workaround or is there any way to achieve the objectiv
mentioned above

Thx
Min

--
Message posted from http://www.ExcelForum.com

Look at John's example

http://j-walk.com/ss/excel/tips/tip49.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"jminu >" <<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi,
> Objective
> *******
> I'm developing an utility where the user is given a option to select a
> color. Then certain cells in the excel will be filled with that color.
> I have a user form where the user chooses the color. I'm using
> CommonDialog.ShowColor to show the dialog.
>
> Problem
> ******
> CommonDialog.Color returns a long. And
> Cell1.Interior.ColorIndex=CommonDialog.Color throws an error. I think
> this is due to the fact that ColorIndex can take values on upto 56
> only.
>
> Is there a workaround or is there any way to achieve the objective
> mentioned above
>
> Thx
> Minu
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>