Thread: Drop Down List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Drop Down List

How about a multi column listbox?

See
http://tinyurl.com/6hakfx
http://www.excelguru.ca/node/34


--JP

On Jun 4, 3:58*pm, Victoria_Wells
wrote:
Hi there

I am really struggling with a list. Basically, I have 3 colums, Product,
Unit & Price.
I want to create a drop down list which allows me to select multiple rows
for a quote, but pulls in all 3 columns, therefore giving me the product
name, the unit it is sold in and the cost per unit, without me having to type
it in everytime. It absoloutely needs to have all 3 columns included, it is
not an option to put everything into 1 column. Is this possible?