Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: VBA Routine to autopopulate field from value picked from com

  1. #1
    Guest

    Default

    Hi. Looking for code that will work the following way: Column D is a drop down list of text values, say "red star", "Blue triangle", "red triangle". When an item is picked Column C would populate the symbols (Wingdings), example is diamond = wingdings "t". I think using some type of Case Selection would work, like case "red triangle" = "t" wingdings.color. (It definately needs to take in consideration the color.) I know how in my head it should work but not proficent enough in programming to complete it. I'm a newbie so be gentle.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This ComboBox you're using is based on what ? Data Validation ? Form Toolbar control ? Control Toolbar ?

    To change the color of a cell just use:

    Range("A1").Font.Color = 255 'For Red
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Dayton, Ohio
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The Combo box works from a Data Validation

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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