no it's no good i'm too under educated (combo box)

[jimmywanna]

Right i'm almost getting it.
I've made the combobox.
I've set it's range.
In the cell link i've typed D13.
now D13 displays the number corresponding to the list.
what do i have to do to make this number become the text.

Thanks to Audiojoe
and Dave Hawley

 

[Audiojoe]

Do you wanna send me your email address and I'll send you a combobox I've been doing

 

[LMF]

do vlookup in another field and u will get the text u want!

 

[jimmywanna]

On 2002-03-19 08:32, Audiojoe wrote:
Do you wanna send me your email address and I'll send you a combobox I've been doing

I DON'T KNOW IF I SENT A REPLY CORRECTLY BEFORE SO I THOUGHT I'D TRY THIS WAY TOO

I'd really appreciate any help.
jamiegibson2002@hotmail.com

thanks

 

[Dave Hawley]

Hi Jammie

Let's say your Combobox "Input Range" is A1:A20. Your Combobox "Cell Link" is B1. In any cell place:

=INDEX(A1:A20,B1)