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

jimmywanna · Mar 19th, 2002, 09:29 AM

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 · Mar 19th, 2002, 09:32 AM

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

LMF · Mar 19th, 2002, 10:53 AM

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

jimmywanna · Mar 19th, 2002, 11:21 AM

Quote:

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 · Mar 19th, 2002, 06:38 PM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 09:29 AM	#1
jimmywanna Board Regular Join Date: Mar 2002 Posts: 182	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

Mar 19th, 2002, 09:32 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Do you wanna send me your email address and I'll send you a combobox I've been doing

Mar 19th, 2002, 10:53 AM	#3
LMF Board Regular Join Date: Mar 2002 Posts: 73	do vlookup in another field and u will get the text u want!

Mar 19th, 2002, 06:38 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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)