How To: Get the index value of the selected color

  • Thread starter Thread starter KM
  • Start date Start date
K

KM

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