Two listbox(activex) to multiple selection options to get the count

**farhanahamed** · 02-22-2013, 08:42 AM

hello everybody & excel VBA experts,
New to forum

Actually my role is to report and preparing the dashboard. I always use excel for reporting. I have a challenge i.e., I have a two listbox (Activex controls) 1st is project & 2nd is country, both are in same sheet, what i want is, if i select the project in listbox1 and also select more than one country in listbox2, it should give the total count of the selected countries for that particular project.

I hope this question is makes sense and understandable. find the attachment for better understanding.
thanks in advance for reply.

I think this very challenging for you.

**xlbiznes** · 02-22-2013, 09:10 AM

Hi,

this code below will solve your problem.

hope this helps.

Happy Computing.

Please Login or Register  to view this content.

**farhanahamed** · 02-26-2013, 02:56 AM

hi,
Thanks for your code. anyway i cant use this, my need is different as based on the post. thanks. Anybody wants to help me for this..

thanks in advance..........!!!!!

**xlbiznes** · 02-26-2013, 04:37 AM

Hi,

Attached is your file with the needed code. Hope i have understood what you really need.

**farhanahamed** · 02-26-2013, 09:15 AM

hi dude,

Thats great.. really works good, but one more to add, i want in the reverse, getting count of selection of multiple projects with one country, is it possible. Much appreciation for your help.

**xlbiznes** · 02-26-2013, 09:50 AM

Hi,

Here you go.

**farhanahamed** · 02-27-2013, 12:00 AM

Hi, Thanks.. thats very very nice.. all the best for you.. i am wondering how people with the great knowledge

**xlbiznes** · 02-27-2013, 01:08 AM

Glad i could help.

If you are happy with the solution, please mark this thread as solved.

**farhanahamed** · 02-27-2013, 08:27 AM

Hi,
The above works well and good, actually that is for one reporting. I want the same for the different, the above just counts between projects and countries by multiple selection, now i added two column which i want the sum (just add two separate cells for this output for the two source data columns). see attachment. thanks in advance. I hope you understand my 2nd requirement