Posted to microsoft.public.excel.programming

Keith

external usenet poster

Posts: 262

How to display Color Palette with vba code

I am trying to pop up the Color Palette to allow a user to pick a color, then
use that color as a background for selected cells. In the past, I have used
the Common Dialog Control to allow users to pick a color. It seems that the
control has disappeared from my list of available controls. Is it not
available in VBA for Office 2003?

I also tried using the XlBuiltInDialog.xlDialogColorPalette but can't seem
to get it to work. Any code samples would be greatly appreciated.
--
Keith

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Color Palette	JAD	Excel Discussion (Misc queries)	1	November 19th 07 02:26 AM
Bring up Color Palette to select color	pokdbz	Excel Discussion (Misc queries)	4	August 6th 07 10:13 PM
Color Palette, color disappears	Emil	Excel Discussion (Misc queries)	3	November 29th 05 05:07 AM
Color Palette	ExcelMonkey[_190_]	Excel Programming	1	February 22nd 05 06:40 PM
Changing color in color palette	Dave Peterson	Setting up and Configuration of Excel	0	December 12th 04 02:39 PM

All times are GMT +1. The time now is 01:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us