Excel Combo Box

  • Thread starter Thread starter wwilhoit
  • Start date Start date
W

wwilhoit

I have created an Excel Combo Box that include ten
different selections. The combo box is linked to a cell.
I want the selection in the combo box displayed in the
linked cell. What I get know is the line number. How do
I correct this?
 
Instead of using the combo on the forms toolbar, try using
the combo on the control toolbar (View/Toolbars/Control
Toolbox) and then set the look up range and linked cell
from the combo's properties.

HTH

Paul
 
You used a dropdown from the forms toolbar?

Then use a helper cell that uses that linked cell:

=IF(A1="","",INDEX(Sheet2!A1:A5,A1))

(My linked cell was A1. My input range was on sheet2, in A1:A5.)
 
Back
Top