you obviously discarded using the Advanced Filter for this?

"tinaw" wrote in message
...

Patrick,

Thanks for your reply, but I really did not want to use a user form.
What I wanted to do was to have an order form in Excel, say in Sheet1.
The user will click on a cell to order the first product and a drop down
list will appear showing products from the inventory list from Sheet2.
In Sheet2 there will be 5 columns showing:
Description, Color, Size, Product Code, Price.

Something like:
Tiki Tank Red Small TK2009 $30.00

There could be about 100 products showing. This is what I want to show
up in the dropdown list on Sheet1, say cell A1 for example. When the
user selects a product from the dropdown list (combobox), I want the
corresponding cells to be populated on the order form, for example: A1,
B1, C1, D1 and E1.

The user then could select many products, so when they click in the
cell below (for example, cell A2), the combobox would show up again so
they could select another product.

If the user selects a product and then changes their mind, I want them
to be able to press delete (like ESC) and they can just undo what they
were doing.

I hope this makes sense. So when they are done it would look something
like the following:

DESCRIPTION COLOR SIZE PRODUCTCODE
PRICE
Tiki Tank Red Small TK2009
$30.00
Jogging Pants Blue Medium JP2008
$25.00
Sweater Green Medium SW2009
$30.00

Thanks for all of your help,

Tina


--
tinaw
------------------------------------------------------------------------
tinaw's Profile: http://www.thecodecage.com/forumz/member.php?userid=355
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=101087