I have a preadsheet that contains lots of data on different partners that we
have.

The partners name will be repeated in every row. So for example you would
have:

Column A Column B Column C

Partner A Other data Other data
Partner B Other data Other data
Partner A...
..
..
..

The user then runs a macro and at some point is required to input the
partners name. At the moment they just type this in but this is open to
spelling mistakes. What I would like to do is create something like a combox
that displays all the partners name in column A.

All I have found so far is list/combo boxes but they repeat the same
pertners name all the way down. What I want is if there a 3 partners then a
selection box that will display those 3 names.

Any ideas?

Thanks