Sorry, make that a combo box, not a list box.

Sheila



On Sat, 21 May 2005 12:03:40 +1200, Sheila
(remove underscores) wrote:

I have a range of data that I wish to use a list box so that the data
of choice is entered into the cell I am clicked into. IE, if i am in
cell B2 and I select from the list box "Product 2), I wish that data
(Product 2) to be entered into B2. How can I do that?

TIA

Sheila