Create A Drop Down Combo Box

[Ray Farrugia]

Hi

I am new at trying to make Excel do more for me, so I hope this won't bore you all!

1.Using Excel 2000 I would like to create a drop-down combo box in Sheet 1 that will be populated with a product list from Sheet 3.

2.Then I would like the selection to be automatically placed into a cell in Sheet 2. Sheet 2 is an invoice so I would like the entries here to be able to printed.

Ray

 

[Harvey]

rightclick on the combobox.
Select properties.
Search in the list for listfillrange.
Fill it with a range, in the order of: Sheet3!A1:A10
Look at the linkedcell property (right above it)
Fill it with a cell, ie Sheet2!A1