Add countIf to textbox (arrays)

Hi,

I have this code:

Please Login or Register  to view this content.

I want to count number for each Item in array (within range) and add them to Textbox, example:

MM : 2
KK : 3 ...

How can I do that ?

Found a solution, in a little different way:

Please Login or Register  to view this content.

This code is only example for first two text values, all others must be just copied. Textbox's property Multiline must be set to True.

If any cell within given range contains string of desired value, It counts that string and puts It in textbox where you want It - In my case result for counting first two strings, separated in new line :

GG : 2
HH : 3

I'm sure this code can be done much shorter, If any suggestions please post It for me !

Regards, Luka