Counting values in Multiple ComboBox's

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm looking for some assistance with excel VBA, it would be great to gain your assistance.

I've created a UserForm with 4 x ComboBox's, each with the same list of values.

I'd like to use a function similar to 'CountIf' for the values selected from the drop box, and if greater than or equal to x, then pop an error msg, and reset to "null"

Thanking you in advance

BJ

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.