I'm using office excel 2007... Is

[wmbb]

I'm using office excel 2007...
Is it possible to open the "Colors Dialog" to pick a color within a macro and to use the choosen color changing the interior of some specific cells ?

 

[HarleyQuinn]

It most certainly is...

I'd have a look into using Application.Dialogs().

What have you got so far?

Hope this helps

Andy
---------------------------------
Zebracorn: 50% Zebra, 50% Unicorn = 100% Real.

http://lessthandot.com

 

[wmbb]

Hi Andy,

I have nothing yet but I was wondering if this was possible.
Now I'm using a fixed number in the macro to define the color and when I want to use an other color I change the value in the macro but I don't want this for the standard users.
Thats the reason I'm asking if this is possible.
I was thinking of something like:

Ccode = application.Dialogs(xlDialog...).Show

I hope this gives an idea of want I want to do.

 

[HarleyQuinn]

Yep, I get the idea

Pseudo code looks something like this:

Select your range (or cell in your range).

Call the dialog (Application.Dialogs(xlDialogPatterns).Show), this will change the interior colour of the selected range/cell.

Ccode should then be set to the Interior.ColorIndex of the selected range/cell.

Hope this helps

Andy
---------------------------------
Zebracorn: 50% Zebra, 50% Unicorn = 100% Real.

http://lessthandot.com