Accumulate count of Combobox selections

  • As you see in the attached excel file
    I have a list of tests, but when I select one of them, the whole combo boxes change as well which I don't want that.
    Every time I select the test from the drop down menu I loose the previous result which I don't want that.
    when choose test 2, I don't want to remove the result of the test 1, I would rather like the result to be accumulated to the first and so on till the 10th test


    please see the attached file

  • Re: Accumulate count of Combobox selections


    Hi zey67


    All of your 10 Combo Boxes are linked to the same Cell (M1) and, accordingly, will assume that value...

  • Re: Accumulate count of Combobox selections


    Hi jaslake,
    I would like to repeat the function of the first combo box for the 9 rest tests.
    When i do the 2nd test i don't to remove the result of the previous test and so on for the rest tests.
    i manage to do the first test but i am struggling in doing the rest

  • Re: Accumulate count of Combobox selections


    Hi zey67


    Far as I know you cannot have multiple selections in your Combo Boxes.

  • Re: Accumulate count of Combobox selections


    Hi jaslake,
    thank you for your reply
    what do you suggest for that purpose?

  • Re: Accumulate count of Combobox selections


    Hi zey67


    List Boxes can be Multi Select...however, I don't see how that fills your need...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!