select from combobox and show a price in textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to allow the user to select something from a combo box then once
selected i want the price to be displayed in either a text box or a list box!
 
i would use a forms toolabr combo box.Click on tha combo box on the forms
toolbar and click on the sheet where you want the box.You can then right
click on it and drag the borders to adjust its size or position.Right click
on the box again and select fornmat control.You will see the following
choices

Combo box properties

Input range Reference to the range containing the values to display in
the drop-down list.

Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.

For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:

=INDEX(D10:D15,C1)
you can now use this result and a vlookup formula to select your price

paul
(e-mail address removed)
remove nospam for email addy!
 
Back
Top