Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

count items in listbox with specific string in column 2

excel 2010 vba
on a userform

I need to update a label with the number of items in a listbox that have a specific value.
in column 2


label12

looking for this term     "EEMRC"

frmR.ListBox1.List(2) = "EEMRC"
??

Thanks
fordraiders
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

How about a dummy sample for testing?
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of [ fanpages ]
[ fanpages ]

PS. fordraiders: I added a revised version of our ongoing workbook development to your existing thread yesterday...

[ https://www.experts-exchange.com/questions/28264352/revise-code-to-not-be-case-sensitive-and-add-additional-sort-column-in-listbox.html?anchorAnswerId=39623969#a39623969 ]

(As you have listed a new question [here], but not responded to my latest comment, I wondered if you had noticed the addition to the previous question)