Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Location
    Michigan, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Color in cells (excel 2003)

    I need a drop down menu (Validation "List", maybe?) and show different colors on the drop down menu.
    I changed some cell colors and Insert:Nameefined them as "Colors" then I went and did a Data:Validation:List:=Colors and it did the drop down like I thought but it had no colors.

    I need the user to have a drop down menu with an assortment of colors to choose from.

    Can this be done with VBA?

    Thank you,
    Craig

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Custom Color in cells (excel 2003)

    Welcome to Woody's Lounge.

    The various dropdown lists available to the Excel developer do not display different colors, at least not without advanced tricks. There are color palettes for fill color and for text color on the Formatting toolbar, but you cannot use them for other purposes.

    You can also use VBA code to display the Patterns tab of the Format | Cells... dialog by itself:

    Application.Dialogs(xlDialogPatterns).Show

    You can display a dropdown list of color names, and use VBA code to apply the color of the selected name to whatever you want to color.

  4. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts

    Re: Custom Color in cells (excel 2003)

    I am not sure if this is a good workaround, but John Walkenbach's site has a Color Picker Dialog Box that is <img src=/S/free.gif border=0 alt=free width=30 height=15> and customizable so it may be adaptable to your needs.

    Steve

Posting Permissions

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