Additional Pallet Colours in Developer Properties

[gyckl]

Hi
I'm trying to colour an object that i've built through the Developer function in Excel through the Properties option. However, the colour pallet under the 'Back Colour' option within Properties only has a very limited range of colours. Does anybody know how to access a larger range of colours - preferably the 'Theme' colours within the Home tab in Excel
Any help much appreciated!!
Cheers

 

[GlennUK]

What object is it?

 

[gyckl]

Combo Box (Active X Controls)

 

[GlennUK]

Have you looked at the Palette choices as well as the System ones ( there are 2 tabs from the dropdown for BackColor )?

 

[gyckl]

Hi
Yeah I have but still the colour I need isn't there
Confusing!

 

[GlennUK]

Do you know the RGB code of the color that you want?

 

[gyckl]

Yes
R= 182
G= 221
B=232

 

[GlennUK]

This code seems to do it:

ActiveSheet.OLEObjects(1).Object.BackColor = RGB(182, 221, 232)