To all,

I have a set of part numbers:

FX1999
FX2000
FCG344
FHJ7867

I want to be able to have a drop down box or list type of thing that
allows the user to select one of these parts. I then want the part
number to be shown in cell C2 of sheet1. I would prefer an answer that
uses a Macro as opposed to defining names/lists etc, and would like the
box to be placed where I choose it on the spreadsheet. i.e. not linked
to a cell like the data validation-lists approach. Is this possible? I
was thinking of using a combo box or list box.

Thanks for your help in advance,

Regards

Joseph Crabtree