List Box-phone number associated

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.

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

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

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"
<[email protected]> 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

Thanks, aphoolatbellsouth.net.

On Tue, 15 Feb 2005 21:53:06 -0600, R P <[email protected]> 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.