+ Reply to Thread
Results 1 to 2 of 2

take action based on multiple drop downs in 1 cell

  1. #1
    Registered User
    Join Date
    01-08-2008
    Location
    Fort Worth, Tx
    MS-Off Ver
    2016
    Posts
    19

    take action based on multiple drop downs in 1 cell

    I am trying to summarize the items selected in a cell which can have multiple selections from the drop down. Here is the code i have
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    The drop down list for the range is numbers 1:10. I want to summarize the total number 1's, 2's etc. for the range.
    Last edited by 6StringJazzer; 04-13-2018 at 03:47 PM. Reason: code tags

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: take action based on multiple drop downs in 1 cell

    I can think of at least two ways to read what you want. It's a little hard to tell without seeing your file.

    You have a bunch of cells that each has Data Validation using List with Dropdown. Each of those dropdowns allows the user to select a number from 1-10. You want to create a list showing for each number 1-10, how many of each number has been selected in the collection of dropdowns.

    Where do you want these counts to go? What cells are the dropdowns in?

    Does your existing code work? It looks like when a user selects a number from a dropdown, you append that to a list in that cell. That would violate the data validation rule, although I have never done that in VBA so maybe it will work.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Change the drop down values, based on selection in other columns(drop downs)
    By zeebee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2017, 01:16 PM
  2. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  3. [SOLVED] Varying validation drop-downs based on varying cell values
    By navarreman1 in forum Excel General
    Replies: 2
    Last Post: 08-08-2013, 08:13 AM
  4. Replies: 17
    Last Post: 02-05-2013, 08:20 PM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  6. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM
  7. Fill cell based on values entered from two drop downs
    By foo.mac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2009, 02:40 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