Forms Combobox output

[Dan Winterton]

I am creating a workbook with several combo boxes, or drop-
down menus. I have successfully linked what the user
selects to an output cell, and I have programmed the
selection choices to come from a range on another
worksheet.

My problem is the output in the linked cell. Rather than
filling it with the exact selection value, it outputs a
number. Example: if the user selects the first option on
the drop-down menu, it outputs a "1"; if a user selects
the 10th item down the list, it outputs a "10".

I am using the combo-box on the FORMS toolbar, NOT the
Visual Basic toolbar. Visual Basic toolbar combobox does
not have this problem. But because I am copying and
pasteing literally hundreds of these, I need to use the
FORMS combo-box: the visual basic combobox does not
maintain the relative cell references when I copied,
pasted.

Any help is greatly appreciated.
Dan Winterton

 

[JE McGimpsey]

Yep, that's the way forms toobars work.

To get the displayed values:

=INDEX(<list reference>,<linked cell reference>)


for instance, if the combobox list is in A1:A10 and the linked cell is
B1, then this will return the list value:

=INDEX(A1:A10,B1)