+ Reply to Thread
Results 1 to 3 of 3

ComboBox Backcolor?

  1. #1
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    ComboBox Backcolor?

    Hi Everyone

    Another one of those obscure (to me) problems that is difficult to sort!

    I have a Combobox on a UserForm.
    Using code I change the .Backcolor property to change the "fill" colour of the box based on its contents i.e. Red, Amber Green (using RGB(x,y,z) in a Select Case construct)
    A sort of coded conditional format.

    This works fine but....

    When I select the list with the dropdown button, the background of the list is also in colour - yuk!!!

    How can I get the background colour of the list to remain white as in a cell Data Validation list?

    I don't want to use a cell Data Validation List.

    As ever WTIA
    barry
    Last edited by barryleajo; 08-26-2010 at 01:57 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,998

    Re: ComboBox Backcolor?

    Easiest way I think is to make the combobox transparent, put a label control behind it, and set the colour of the label instead. See attached file.
    Attached Files Attached Files
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: ComboBox Backcolor?

    Hi Again romperstomper
    As ever a perfectly formed solution!
    Such little tweaks make applications so much more professional looking.
    Your expertise and experience helps give solutions not readily available elsewhere.
    Thanks for passing this on.
    Many thanks mate - always appreciated
    As ever the scales will be bouncing!

    Oh and thanks also for the quick response.
    barry

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1