Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lines in List Box?
I don't know if this is the right forum but I am trying to make a listbox that will hold more then one line of information so that I can populate other parts of the worksheet. Here is an example when you pick the name: Herman you will populate Herman with his address, phone number, etc.... Like a database but in Excel. Is this possible? I know how to do the single line list box but can't find no information on a multi-line one.... -- solitaire ------------------------------------------------------------------------ solitaire's Profile: http://www.excelforum.com/member.php...o&userid=30883 View this thread: http://www.excelforum.com/showthread...hreadid=505626 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lines in List Box?
I'm not sure why you want to hold the data in a list box.
Hold the data in an excel list where the name (assumed to be a unique identifier) is the key field. Then in the cells which need populating use a formula like =vlookup(SelectedName,tblExcelList,DataType,False) The DataType would the column number of the lookup table. I hope this helps Phil "solitaire" wrote: I don't know if this is the right forum but I am trying to make a listbox that will hold more then one line of information so that I can populate other parts of the worksheet. Here is an example when you pick the name: Herman you will populate Herman with his address, phone number, etc.... Like a database but in Excel. Is this possible? I know how to do the single line list box but can't find no information on a multi-line one.... -- solitaire ------------------------------------------------------------------------ solitaire's Profile: http://www.excelforum.com/member.php...o&userid=30883 View this thread: http://www.excelforum.com/showthread...hreadid=505626 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
How do I group multiple lines of excel info for easy sorting | New Users to Excel | |||
select lines from multiple worksheets and write to new worksheet | Excel Worksheet Functions | |||
How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |