View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Keith is offline
external usenet poster
 
Posts: 262
Default 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