• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1689
  • Last Modified:

Excel 2010 VBA combobox backcolor

Since we have a lot more color choices in 2007 an 2010 - is it possible to use BackColor other than the ones that come up in the Color Palette? (56 colors)

I'm familiar with &HC0C0FF etc. I wonder is that extends to all the possible colors in Excel 2010 and how I would get that color code for any given color.

Is it possible to, and has someone have suggestions for a methodology for combining that with Styles?
Thanks
0
hindersaliva
Asked:
hindersaliva
  • 2
  • 2
1 Solution
 
SeanStricklandCommented:
Have you tried using RGB()?  It's RGB(red [0-255], green [0-255], blue [0-255]).  It lets you set your own red/green/blue value to create any color you want.

Example:
Me.ComboBox1.Backcolor = RGB(200,100,50)

Open in new window

0
 
hindersalivaAuthor Commented:
Perfect. So simple.
0
 
hindersalivaAuthor Commented:
Any further discussion/links on Excel 2010 VBA Styles strategies welcomed.
0
 
SeanStricklandCommented:
Glad I could help.  Thanks for the grade.

Cheers,
Sean
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now