TextBox Data

[colmguckian]

I have a user form with a ComboBox and a TextBox.
The ComboBox is Populated using a named range for the Row Source Property. The range is on column B Sheet1. I have an associated Price value for each Value in the named range. The associated Price value is in the same Row Column C. I need a Code that will display the Price in the text box for each item selected in the ComboBox. Please

 

[Norie]

Well since only one item can be selected in a combobox you can just use the ListIndex of that item to get the row it's on in the worksheet.

Pretty straightforward if your data starts in B2.

Textbox1.Value = Worksheets("Sheet1").Range("C" & ComboBox1.ListIndex+2).Value

 

[colmguckian]

Thanks Noie. That Works great.