PDA

View Full Version : Solved: Combobox Colors



Brillian
05-21-2009, 12:39 AM
Hello,

I am new to VBA using Excel 2007 and currently developing a Area of Triangle Calculator as well as drawing the triangle.

I plan to add another feature in the form which is a Combobox and the choices are colors with index (1-56). The actual colors will be displayed in the combobox.

Anyone can help me? Thanks in advance.

Cheers,
Brillian

Bob Phillips
05-21-2009, 01:25 AM
Don't think you can do that. Why not throw up a simple colour palette to select from?

Andy Pope
05-21-2009, 02:17 AM
You can fake it.
http://www.andypope.info/vba/colourdropdown.htm

But as Bob says you will be better off creating a palette.
http://spreadsheetpage.com/index.php/file/a_color_picker_dialog_box/

Brillian
05-21-2009, 08:17 AM
Thanks for the reply. It really helps..