Count from Input box

D

DB100

Hi all

Just a quick one...

I have a list of data that has no more than 30 differing names. Bu
there about 10000 entries

To complete something I am working on, I need to be able to count ho
many times a name may appear in the list, depending on what name i
entered in the text box on my user form.

Hope you can help

Thank
 
T

Tom Ogilvy

num =
Application.Countif(Range("A1:A10000"),worksheets("Sheet1").Textbox1.Text)
 
Top