Count the number of names appearing in a certain cell

[Shazklebolt]

Hi everyone!

New to excel VBA and I am a newly appointed minute taker for my department meeting.

I have a sheet with an activeX control - command button that generate names randomly based on the list given.
The name generated will appear on my Sheet2 (Nominee) cell B2.
The name generated will also be randomized and can be duplicated.

I have difficulty trying to execute the command below.
I will like to count the number of times the name appear in B2 every time I clicked the command button.
The counter will not reset if I clicked the command button.
The counter will increase +1 for every duplicated name after I clicked the command button.

Under selection, how should I go about when the counter shows "3" a MsgBox ("TheNameBesideTheCounterBox") will appear?

Thanks for helping me figure this out!

[ikboy]

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[Shazklebolt]

Thanks ikboy! Works like a charm! I'll study the code and hopefully understand it

[Shazklebolt]

Wow, your code is much more direct by applying it onto the command button itself. Thanks! I'll study this as well! Though I will be disheartened when I see application.worksheetfunction, etc.