MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Single Select List Box


Posted by Caswell Gilkes on June 14, 2001 7:47 AM

I have created my listbox, I have my dropdown arrows on each row but the listbox contains the range in the excel sheet where my list is not the Mortgage Companies. I also want that when I selectt the company it returns the code in the bound column. Can anyone help me? I have no knowledge about VB and i just happened to stumble across it 3 weeks ago.

thanks


Posted by Joe Was on June 14, 2001 8:02 AM

Go to Data-Validation, first Tab select type- List, in the data box type your lit items, use a comma " ," to separate list items or make a list anywhere in your workbook. If your list will have items added to it periodically name the range and re-name it the same name with each update. Then in the list data box reference the sheet list with:
=your list name or =AX500:AX510 (as you would a normal range)

Each item in a dropdown list, is its own item you cannot select more than one! JSW

Posted by Aladin Akyurek on June 14, 2001 8:08 AM

If the elements of the list that you use and the Mortgage Companies are next to each other in some sheet, you can use a VLOOKUP formula.

Lets say that you have a dropdown box in A1.

In B1 enter: =VLOOKUP(A1,Table,2,0)

where Table is the range that contains the values that you can select from the dropdown box and the Mortgage companies next to each other.

Aladin