Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,069
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does the default Excel color palette change between workbooks ajkajkajk Excel Discussion (Misc queries) 1 December 18th 08 06:05 PM
In MS 2007 Office, how do I set default color palette same as 93-2 Ed L. Excel Discussion (Misc queries) 0 August 27th 08 08:10 PM
How do I get the color palette back to the default setting? JacMac Excel Discussion (Misc queries) 3 June 18th 08 01:05 PM
How to change the default interior color palette index in Excel 2003 [email protected] Excel Programming 1 March 29th 07 03:04 AM
Excel - Customize Default Color Palette brontesan Excel Programming 2 August 28th 04 01:47 AM


All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"