View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] csugden@gmail.com is offline
external usenet poster
 
Posts: 15
Default VBA color picker - copy of Font dialog combo box

Hi,

I've had a look at a lot of color picking code for userforms, but I was
wondering if there was any way of just producing the same combo box
that can be found in Format--Cells--Font (I'm using Excel).

I've looked at various application.dialogs, but they would confuse my
users - all I need is the colour, and the way it is done in the Font
page seems ideal.

Either an inbuilt solution (i.e. something within excel that I can
reference, like a dialog) or a copy would be fine. Anyone seen anything
like this?

Thanks very much,

Chris