Combo Box

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

Dave Peterson

It sounds like you used a combobox from the Forms toolbar.

If your linked cell is A3 and your list of 6 strings is in B1:B6, you could use
this:

=if(a3=0,"",index(b1:b6,a3))

in A2.

There's a combobox on the ControlToolbox toolbar that returns the value of
combobox into the linked cell.

And another similar function is Data|Validation.

See Debra Dalgleish's site for more info:
http://www.contextures.com/xlDataVal01.html

(Usually, Data|Validation is the easiest to implement.)
 
Hi folks! I'm hoping some one can direct me to some info on using and
retrieving information from a Combo Box.

What I am doing in short is:

Cell A1 Would be a Combo Box with 6 different strings of text to choose
from.

Cell A2 Would be the Text String selected from the Combo Box in A1

Cell A3 Is the Cell Link for the Combo Box in A1.

My question is:

The Result in A3 is a numeric result representing what is selected in A1..
I now want the Text selected in A1 to show in A2. How do I turn the numeric
result in A3 back into the text string selected in A1?

Thanks in advance for any help you can give me.
--
Have Fun Bill

RealDraw Cafe
http://realdrawcafe.com
MicrosoftGraphics Users Group
http://microsoftgraphics.com
 
Back
Top