Loop through a data validations list and for each loop count the number of occurences

**waimea** · 07-03-2018, 11:20 AM

I have cross-posted this at https://stackoverflow.com/questions/...lidation-lists and on https://www.mrexcel.com/forum/excel-...ion-lists.html

I am trying to loop through 2 pairs of data validation lists, 4 data validation drop downs in total.

With every loop of the data validation lists I would like to count the number of occurrences of two symbols and

then save the result of each loop in a variable or a worksheet or both.

I have found a bit of code that I think could be a starting point to work from.

Please Login or Register  to view this content.

**waimea** · 07-03-2018, 11:30 AM

I found this bit of code https://stackoverflow.com/questions/...-dropdown-list

It doesn't work for me though.

Please Login or Register  to view this content.

**waimea** · 07-03-2018, 11:39 AM

I think that a for each loop is what I am trying to do?

**waimea** · 07-03-2018, 05:25 PM

Any suggestions on what I need to read or learn to make this possible?

Or any suggestions on how I should go about?

**Marc L** · 07-03-2018, 06:31 PM

Just attach a workbook here …

**waimea** · 07-03-2018, 06:35 PM

attachment-doesn-work.png

Attachment doesn't work for me at this forum, I am using Chrome but I just tried with Internet Explorer and the attachment part is just a tiny box

**Marc L** · 07-03-2018, 06:39 PM

So just use any better webbrowser …

**waimea** · 07-03-2018, 06:48 PM

I have tried with two different browsers :/

**waimea** · 07-04-2018, 06:22 AM

Please Login or Register  to view this content.

How can I improve this code? Instead of Debug.Print I would like to select a new worksheet and update the new worksheet?

Also, I am using dependant drop downs for two of my four data validation lists and I get a type mismatch since I am using INDEX and MATCH to find the correct value.

How can I change the code above to account for the type mismatch?

**waimea** · 07-05-2018, 05:52 AM

From this thread https://stackoverflow.com/questions/...lidation-lists

I have the following code. It doesn't work for me though!

Any suggestions on how to call the code?

Please Login or Register  to view this content.

**Marc L** · 07-05-2018, 06:02 AM

As it's yet explained in the procedure name : ExtractDataValidationList {TheSourceRange}, {TheDestinationWorksheet} …

Parameters between { } - including { } - must be replaced with objects expected by this procedure …

**dominicb** · 07-05-2018, 07:31 AM

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

**waimea** · 07-06-2018, 06:48 AM

For starters, this code is what I would like the result to be.

How can I add VLookup in VBA to this code?

Please Login or Register  to view this content.

with 2 drop down list with 4 options each (option1, option2, option3, option4) I get the following output.

Please Login or Register  to view this content.

**waimea** · 07-08-2018, 05:22 AM

Please Login or Register  to view this content.

How can I change this code to loop through two data validation lists?

Loop through a data validations list and for each loop count the number of occurences

LinkBack

Thread Tools

Rate This Thread

Display

Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Re: Loop through a data validations list and for each loop count the number of occurences

Thread Information

Users Browsing this Thread

Similar Threads

Loop through list, add to Array, count number of occurrences, clear array

[SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number

[SOLVED] Count number of occurrences for a number of ranges from a find loop

Do-While loop within a do-while loop? Dealing with changing number of rows

VBA For loop where number of iterations can be changed from inside loop

Loop (Number Count)

[SOLVED] How to count number of occurences in an autofilter list

Bookmarks

Bookmarks

Posting Permissions