+ Reply to Thread
Results 1 to 18 of 18

Trying to add a drop down menu that updates as I add more items

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Trying to add a drop down menu that updates as I add more items

    Hello,

    I am wanting to add a drop down menu to the 'Orders' column. I'm wanting the items to have selectable check boxes so that I can choose what type of orders I want to view. I also want it to update the selectable options each time I enter a new type of order to the list. Is this possible? Any and all help would be greatly appreciated!! Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    Try the attached file. Click in cell D1 and make a selection.
    Attached Files Attached Files
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    Thank you so much for your help!! When I try to open the attached file though, I get this error...SharedScreenshot.jpg

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    Try the attached version.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    That's great!! Thank you!! Is there a way to get it to recognize multiple entries in one cell though? Instead of it creating a new drop down option that lists 3 different orders, I need it to recognize that cell anytime it has "HIV Screen" (for example) instead of creating a new option for "HIV Screen, Urine Culture, Pap Smear" etc.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    I'm sorry but I don't follow what you mean. Could you explain in detail what you want to do referring to specific cells, rows, columns using a few examples from your data?

  7. #7
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    I need the database to still show me "HIV, Urine Culture, Pap Smear" when I've selected "Pap Smear" from the drop down menu. I also don't want it to create a new menu option for these multiple listings. I only want a new menu option to be created when I enter a single item. Sorry I'm not able to explain this better! I don't know a lot of the terminology within excel.

    For example, if I added "Blood Draw" to D20, I want that to automatically be added as an option to the drop down menu. But if I were to add "Blood draw, Pap Smear, HIV" I don't want that to become an option. Also, if I selected "HIV" from the drop down menu, I'd want the entry "Blood draw, Pap Smear, HIV" to still appear. I would also want it to appear regardless of whether it typed "HIV" or "hiv" or, for another example, "Pap smear" vs "Pap Smear".
    Last edited by Klea; 06-29-2021 at 01:20 PM.

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    See if the attached version does what you want.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    Yes!! :D That's perfect!! Thank you! For selecting multiple entries (for example, if I wanted it to show me all the entries with "HIV" and/or "Urine culture") is that something I just have to do manually within the filter? Or is there a way to select multiple drop down options?

  10. #10
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Trying to add a drop down menu that updates as I add more items

    A bit extended version.
    Please Login or Register  to view this content.
    Details in the attachment.



    Quote Originally Posted by Klea View Post
    Or is there a way to select multiple drop down options?
    The validation list does not allow multiple selections. You can do this, but you'd have to use a ListBox control that allows multiple selections.
    Although ... check out the site:
    [url]https://trumpexcel.com/select-multiple-items-drop-down-list-excel/[url]

    Artik
    Attached Files Attached Files

  11. #11
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    Place these 2 macros in the worksheet code module:
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    Thank you for your response! I ran into a few hiccups trying these out though. When I try just copying the code that you included, I get this error:

    Attachment 738500

    And when I try just using the attached file, I get this error:

    Attachment 738501

    Also, thank you for the article!! That is super helpful!!

  13. #13
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    I assume that in your last post, you are referring to @Artik's post. Have you tried the code I posted in Post #11? It should do everything you requested.

  14. #14
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    @Mumps1 Yes, I was! Sorry for the confusion. And I am attempting to try the code you posted now. I'm running into some issues though when I try to do a second search. It does everything I asked, thank you so much for that!! But when I'm done with whatever search I was doing and then attempt to do a different search, I get this error:

    Attachment 738505

  15. #15
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    @Mumps1 This is what it shows me:

    Attachment 738507

  16. #16
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    Replace the current code with the following:
    Please Login or Register  to view this content.
    Each time you want to add another search criteria in D1, make sure you click the down arrow to the right of cell D1. When you want to start a new search, press the DELETE key while D1 is the active cell to delete all previous criteria and make your new search selections.

  17. #17
    Registered User
    Join Date
    08-29-2018
    Location
    Indiana, US
    MS-Off Ver
    2016
    Posts
    36

    Re: Trying to add a drop down menu that updates as I add more items

    Perfect!!! Thank you so much for all your help!! :D

  18. #18
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Trying to add a drop down menu that updates as I add more items

    My pleasure.

+ 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. Drop Down Menu updates the data in the corresponding cells
    By nancypnp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2015, 11:23 PM
  2. Replies: 0
    Last Post: 11-03-2014, 12:14 AM
  3. Replies: 3
    Last Post: 08-23-2012, 12:43 PM
  4. Word Form - How to print a list of fields and drop down menu items
    By HighlandScott in forum Word Formatting & General
    Replies: 31
    Last Post: 02-23-2009, 08:09 AM
  5. select multiple items from drop-down menu
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 05-25-2008, 11:50 AM
  6. Drop down menu lists items from a table
    By Nate5452 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2007, 06:47 PM
  7. [SOLVED] Deleting items as they are used from a drop down menu
    By ToferKing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2006, 06:10 PM

Tags for this Thread

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