Im creating a system as part of a school project.
I have this drop down list.
'[image: http://img35.imageshack.us/img35/825...wnlist3zs.jpg]
(http://imageshack.us)
The product codes (C001 etc) are in written in a cells which are no
hidden and i have used a VLOOKUP so the description from another shee
(ProductList) shows the description of each product when select.
Now i have this box on the same sheet as the drop down list.
'[image: http://img5.imageshack.us/img5/4425/productbox5im.jpg]
(http://imageshack.us)
Basically i need a macro which i can attach to a button so that when
product is selected i can click "Add to Order" and it appears in th
box and then i select another product and it does the same thing.
I hope i have made myself clear.
Grateful for any help.
Luke

--
Luke
-----------------------------------------------------------------------
Lukey's Profile: http://www.excelforum.com/member.php...fo&userid=3051
View this thread: http://www.excelforum.com/showthread.php?threadid=50168