Hi,
If a use the following code to show the Colour Palette
dialog box, how to I retrieve the selected colour index
value. Application.Dialogs(xlDialogColorPalette).Show

TIA
K

This is the same as selecting it from the menu - it doesn't return the color
selected - it applies it to the activecell. You would have to read the
value of the interior.ColorIndex of the activecell after the user makes a
selection and it is applied. You cant use this dialog as a general interface
for having the user select a color.

--
Regards,
Tom Ogilvy

"KM" wrote in message
...
Hi,
If a use the following code to show the Colour Palette
dialog box, how to I retrieve the selected colour index
value. Application.Dialogs(xlDialogColorPalette).Show

TIA
K