Just supposing I have 3 fields in columns A, B and C named Item,
Quantity and Price, I want to know how to get all of this data to
appear in a combo box. Does anybody know how to do this?

Then, if one record was selected from the combo box, I want this record
to be placed somewhere else on the spreadsheet e.g. to the right of the
combo box. Is there an easy way of doing this?

Thanks in advance.

James


--
run_PAFC
------------------------------------------------------------------------
run_PAFC's Profile: http://www.excelforum.com/member.php...o&userid=24673
View this thread: http://www.excelforum.com/showthread...hreadid=382565