View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
 
Posts: 211
Default Pick a color from the default palette

I want the user to select a color from the DEFAULT color palette that pops up
usually. How can you call the color palette so as to derive the code/index of
the color select.

A sample code for the following task shall be appreciated if provided:

Macro runs
Default Color palette appears
Color selected/picked
Color of the Active Cell or of the Fonts' of the active cell changed to the
color selected/picked so.
Macro ends

--
Thanx in advance,
Best Regards,

Faraz