ComboBox on worksheet-strange outcome

  • Thread starter Thread starter goss
  • Start date Start date
G

goss

Hi

Using xl xp pro

Have 2 combo boxes on wrksht
CB1 is linked to cell B1

When I choose unit 20 from my list in the combo box
unit 15 is placed in cell B1

Other times whatever I choose is exactly what is placed in cell B1

Any idea what is going on?
 
What combobox are you using?

From the Controltoolbox toolbar or the forms toolbar?

The controltoolbox toolbar returns the value of the combobox in the linked cell.

The forms toolbar returns the index into the list.

If you right click on the combobox and see "assign macro", you've used the Forms
version.

Then you could use a helper cell with a formula like:

=INDEX(A7:A21,B1)
=index(inputrangeaddress,linkedcelladdress)
 
Back
Top