Results 1 to 5 of 5

Thread: Drop Down List Or Data Validation List To Insert Text In To Cell Range

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0

    Drop Down List Or Data Validation List To Insert Text In To Cell Range

    Greetings

    I am setting up a new workbook and would like some help getting started.I used 2 control as they give larger size fonts then D.V Lists.I have posted a sheet which explains where I need help

    Regards

    Reg
    Attached Files Attached Files

  2. #2
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    12
    See attached. Used Data Validation. Seems the simplest method and adjusted the font size for the particular row.
    Attached Files Attached Files

  3. #3
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    depending on the finished worksheet I find that sometime the data validation list becomes almost unreadable due to size of letters.You sample is good though.If I require a control form button such as a combobox will that work as well in the same way as your sample?
    Also I need to sometimes have the same words for the different list colors in data validation list.I get an error with my formula.Please see
    Regards
    RegC
    Attached Files Attached Files

  4. #4
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    12
    Hi,

    In C15 try this: =IF($C$9="Blue Water";"Chill";IF($C$9="red water";"chill";""))

  5. #5
    Junior Member
    Join Date
    Jul 2013
    Posts
    20
    Rep Power
    0
    Thanks

Similar Threads

  1. Replies: 2
    Last Post: 07-23-2013, 06:54 PM
  2. Change Data Series In Chart Using Drop-Down List
    By raybugge in forum Excel Help
    Replies: 2
    Last Post: 07-06-2013, 03:02 PM
  3. Change Pivot Table Data Source Using A Drop Down List
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-05-2013, 09:33 AM
  4. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 01:57 AM
  5. VBA Validation List set
    By xander1981 in forum Excel Help
    Replies: 3
    Last Post: 02-15-2013, 04:07 PM

Posting Permissions

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