Need Combo Box Help

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

I used the Forms Tool to setup a combo box

Enter following data in B1:B3
B1 = yes
B2 = no
B3 = maybe

Click Combo Box control from Forms Toolbar

Right Click the Combo Box and then click Format Control

On the control tab enter...

Input Range: B1:B3
Cell Link: =INDEX(B1:B3,C1)

No Workie... I want to be able to have the word "yes" or "no" or "maybe"
show up in cell C1 when someone selects them from the combo box.

Clearly I'm missing something. Thanks for any help.
 
How about making your cell link D1 (just D1--not a formula). Then use this in
C1:

=INDEX(B1:B3,D1)

The linked cell returns a index number into that list--not the value itself.

But if you used the combobox from the Control toolbox toolbar, the linked cell
is the value in the combobox.
 
Dave,

I got it... I need to do as you said and put the INDEX formula in another
cell. Have it working now.

thanks
 
Back
Top