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

Pick a color from the default palette
 

have a look at this site. there is a free color picker tool you can download
which may do what you want

http://spreadsheetpage.com/index.php...er_dialog_box/
--
jb


"Faraz A. Qureshi" wrote:

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

Pick a color from the default palette
 

Thanx again bro! Already have that imitative palette.
So the default palette can't be accessed via a macro?
--
Best Regards,

Faraz


"john" wrote:

have a look at this site. there is a free color picker tool you can download
which may do what you want

http://spreadsheetpage.com/index.php...er_dialog_box/
--
jb


"Faraz A. Qureshi" wrote:

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