ComboBox on worksheet-strange outcome
 

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?


---
Message posted from http://www.ExcelForum.com/

ComboBox on worksheet-strange outcome
 

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)



"goss <" wrote:

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?

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson