software

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: www.excelforum.com/member.php...oamp;userid=30883
View this thread: www.excelforum.com/showthread...hreadid=505626I'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

quot;solitairequot; wrote:

gt;
gt; I don't know if this is the right forum but I am trying to make a
gt; listbox that will hold more then one line of information so that I can
gt; populate other parts of the worksheet.
gt;
gt; Here is an example when you pick the name: Herman
gt;
gt; you will populate Herman with his address, phone number, etc.... Like a
gt; database but in Excel. Is this possible? I know how to do the single
gt; line list box but can't find no information on a multi-line one....
gt;
gt;
gt; --
gt; solitaire
gt; ------------------------------------------------------------------------
gt; solitaire's Profile: www.excelforum.com/member.php...oamp;userid=30883
gt; View this thread: www.excelforum.com/showthread...hreadid=505626
gt;
gt;