VBA Code - creating a percent for different categories in a column

I have an excel document where in one column there are 7 different categories that could be in it.
The categories are "RTW, ACC, HBG, HOM, JWL, SLG, SHO" I am trying to code in a command button a way to scan hundreds of cells in this column and make a percent of how many are RTW, ACC, etc.

Also how would I be able to demine which category is the most used in that column???

Thank you so much! Do you know how I would go about finding which category is most used in the column? Like doing it separate from the percent?