Excel Combo Box Probelm

[dustbuster]

Hello all,

I have a Combo Box on Sheet1 in my workbook.

Sheet 2 has a list of products in Column A and their price in column B

I populate the combo box with products listed in Column A of Sheet2.

How do I get the price of a product when it is selected from the list?

 

[TonyJollans]

Hi dustbuster,

It rather depends on what else you're doing as well, but I would probably have two columns in the combo. Try setting the combo properties something like this:

ListFillRange:   Sheet2!A1:B200   (or whatever your rangle is)
ColumnCount:     2
BoundColumn:     2
ColumnWidths:    8;0
TextColumn:      -1

This should make the Products show in the combo and make both the name and the price available as properties of it.

Combo.Value should have the price and
Combo.Text should have the product

Enjoy,
Tony

 

[dustbuster]

Thanks Tony! That works for me.