Using a custom colour palette

[cdhoughton]

Hi all,

I have a form with a combo box and loads of buttons. I am trying to change the colour of all the buttons according to the combo box. If some of you have read my earlier posts I now know how to do this in principal!

However, is there any way, to improve the appearance of the form, of populating the combo box automatically using the default palette? Let me elaborate:

Ideally, the combo box will have a little colour square exactly like the palette in VBA and its name, and then when the user selects the colour in the box all the text on the buttons change colour.

Any ideas of a quick way around this (without populating using all the hex codes manually typed in)???

 

[Greg Truby]

Not sure, but this might help? In this thread, I posted a subroutine that puts the pallet in cells in the same layout as the Excel default pallet. At least it gives you the sequence you'd need.

HTH

 

[cdhoughton]

Cheers Greg, it's certainly given me somewhere to start!

 

[tusharm]

Check VB(A)'s Common Dialog Control ( http://msdn.microsoft.com/library/d...-us/vbcon98/html/vbconcommondialogcontrol.asp)

 

[cdhoughton]

Cheers for that, I'll see if I can implement it now!!