Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List Box
Is it possible for Excel to populate several cells with unique values
using one List Box field? A list box contains values 1 to 10 and depending on which value I choose, a name, address and phone number associated to that value would be populated into various other cells. |
#2
|
|||
|
|||
Hi,
Absolutely....Use the INDEX formula to populate the cells you want from the source data based on the LinkedCell property of the ListBox (assuming it is a Listbox from the Forms toolbar). If you need an example post your email address (with "at" replacing "@") to this thread and we can talk further. Hth, Oli -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
Hi Oli I'm using/making a file/workbook that will contain a 1000 sheets plus and I think RP's idea may help me reduce my load, if what you say is easily done for all 1000 sheets easily. I've a number of cells repeated on all but a few of each sheet that could use the ease of adding a number to produce a text result from a range. If this is the case, pls email me an example to liamlatrineathotmail.com Thks in advance, Liam -- liam ------------------------------------------------------------------------ liam's Profile: http://www.excelforum.com/member.php...o&userid=19989 View this thread: http://www.excelforum.com/showthread...hreadid=345755 |
#4
|
|||
|
|||
Thanks, aphoolatbellsouth.net, attached is a sample file that I am
trying to work with. On Wed, 16 Feb 2005 06:54:32 GMT, "Oliver Ferns via OfficeKB.com" wrote: Hi, Absolutely....Use the INDEX formula to populate the cells you want from the source data based on the LinkedCell property of the ListBox (assuming it is a Listbox from the Forms toolbar). If you need an example post your email address (with "at" replacing "@") to this thread and we can talk further. Hth, Oli |
#6
|
|||
|
|||
Thanks, aphoolatbellsouth.net.
On Tue, 15 Feb 2005 21:53:06 -0600, R P wrote: Is it possible for Excel to populate several cells with unique values using one List Box field? A list box contains values 1 to 10 and depending on which value I choose, a name, address and phone number associated to that value would be populated into various other cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
Comparing two List that a "Close" but not Identical | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |