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
