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