Does anyone know how to write code in VBA that will calculate the frequency of strings from a list?

the kicker:
-there is no predefined number of strings
-there is no predefined list of strings to reference

so each time a new data set is entered the total number of entries may change, and the order and composition of the list of strings may change.

I appreciate any help that you may be able to give.

Thanks!