+ Reply to Thread
Results 1 to 11 of 11

Drop Down List of Codes With Descriptions

  1. #1
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Drop Down List of Codes With Descriptions

    Hello,

    I have drop down lists of codes. Can the description of the codes show also but only apply the code to the cell?

    Thank you

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Drop Down List of Codes With Descriptions

    Provide a better explanation, since english is your native language
    Click the * to say thanks.

  3. #3
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Re: Drop Down List of Codes With Descriptions

    I take it that is sarcasm which I don't think is appropriate. If you don't want to help why reply?

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Drop Down List of Codes With Descriptions

    Well, I want to help you, but as I said, you should provide a better explanation. Is not sarcasm or anything

  5. #5
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Re: Drop Down List of Codes With Descriptions

    I heard of combo boxes that can show multiple columns is this true?

  6. #6
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Drop Down List of Codes With Descriptions


  7. #7
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Re: Drop Down List of Codes With Descriptions

    This won't be a good solution but thanks for trying. I have these drop down lists in very many places on the worksheet. It would be better to sort of have one place that the user can select to find out what the codes mean. Perhaps a button for one type of code list and another button for the other type of code list.

    One list is for labor types of codes LB101, LB102 etc.
    The other list is for materials MT101, MT102 etc.

    I attached the file and on the Invoice Data sheet there are multiple columns with Codes that have the drop downs.

    I imagined buttons to pop up what the code descriptions are if the user needs.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Drop Down List of Codes With Descriptions

    Is this more like what you wanted?

    https://www.mrexcel.com/forum/excel-...nly-one-2.html
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  9. #9
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Drop Down List of Codes With Descriptions

    you could use some location (though seeing your workbook I'm not sure where you'd want it) that you could put in the code, either typed in or from a dropdown and in the cell next to it would populate the description. Is that what you are wanting? If so you ought to show on your workbook where you want it and where all the descriptions would come from, the materials tab, the labor tab, another tab (which could be hidden) that would contain all the codes and definitions?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  10. #10
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Re: Drop Down List of Codes With Descriptions

    Thanks I will put hyperlinks to the tables. I apologize for asking an unnecessary question.

  11. #11
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Drop Down List of Codes With Descriptions

    No apology needed for asking a question! If it was "necessary" for you it deserves being asked.
    I've asked questions then when gotten answers thought D'uh, seemed so simple shouldn't have asked. Any question is worth considering as even if it didn't help you it might be a help to someone else.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Access Query/SQL display table code descriptions for multiple codes
    By WBravard in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-04-2018, 07:40 AM
  2. [SOLVED] Drop down list that displays descriptions
    By SaraLynne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2014, 03:26 PM
  3. Filter Zip Codes from a list codes
    By jaugent27 in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:01 PM
  4. Replies: 0
    Last Post: 08-16-2012, 02:01 PM
  5. Adding descriptions to product codes
    By paulboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2009, 05:26 AM
  6. Create list of unique descriptions for each term
    By lae1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2008, 04:16 PM

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