Excel Combo Box

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?
 
P

Paul Falla

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
 
D

Dave Peterson

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.)
 
Top