Accessing Color palette values

[jminu]

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

 

[Ron de Bruin]

Look at John's example

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