fullers,

Not quite what your asking for , but if you enter this in data validation as
a "Custom" type in cell A6 it will only allow values from A1 to A5:

=COUNTIF($A$1:A5,A6)0

Combined with the Autocomplete feature of Excel (where it fills in a cell
value from above in that column) this might work for you.

hth,

Doug

"fullers" wrote in message
...
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