Text Box Update

[colmguckian]

I have a user Form with 3 ComboBoxes and 1 Text Box.
The Values in ComboBox2 depends on the selection in ComboBox1.
The Values in ComboBox3 Depends on the selection in ComboBox2.
I Want TextBox1 to Show a Price, depending on which Item in ConboBox3 is Selected. All ComboBoxes are populated using the RowSource Property.
The RowSources are the named Ranges in Column B of sheet1.
The associated Prices for each Value in Column B are on the Same Row in Column E. How would I get these prices to appear in TextBox1.

 

[tweedle]

You can try this:

Set your named range that is the rowsource to encompass your data B through E;
Set Combobox3 Columns to 4
Set ColumnWidths to 10 pt;0 pt;0 pt;0 pt <-set to 10 if you want to show them the price in the combobox.

Essentially, you're loading the price into the combo box array (along with whatever is in C & D).

then it's pretty simple to assign the value to textbox.

Private Sub ComboBox3_Change()
TextBox1.Text = ComboBox3.List(ComboBox3.ListIndex, [B]3[/B]) 'the column index here is always option base 0 
End Sub