Accessing Color palette values

  • Thread starter Thread starter jminu
  • Start date Start date
J

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
 
Back
Top