Count the number of duplicates in a range and then create a ranked sort

Hi

I have been scouring the web for info on this without success!

I have a userform where users can input names of suppliers. As this list is built up, I want to have option buttons that have a caption name based on the most popular supplier name so that they can simply chose a supplier by clicking the appropriately named supplier. So, if after 10 entries, supplier "Smith" has been inserted 6 times and supplier "Jones" inputted 2 times and two other suppliers have been inputted once, I would like to have OptionButton1.Caption="Smith" and OptionButton2.Caption="Jones" created on the userform.

This requires code for counting duplicates and ranking the result. I can't seem to get started on this!! Can anybody provide any guidance/help?

Cheers

Wow! MarvinP...this is just what I was looking for! Thanks very much.

I think it will be worth the effort as my users are not too computer literate and would much prefer to use click buttons rather than typing names all the time. My next problem will be to make sure that they spell the names consistently and correctly rather than "Smith", "smith", "Smitgh" etc!!!

Thanks once again for your help.