Hello,

I have made an userform with 3 comboboxes. To fill a combobox it search a column. There are some empty cell is the column, but it does not put in the combobox. So that is good.
Now i want to show in a textbox the value of the cell beside the selected item in the combobox. For example: i select "bike" in the combobox which is located in a6, i want to know what value is in b6.

This is the code i created for filling the combobox:

Sub fill_combobox1()
ComboBox1.Clear

Dim Parameters As Range
Set Parameters = Worksheets("Parameters").Range("A5:A200")

For Each Cell In Parameters
If Cell.Value <> "" Then
ComboBox1.AddItem Cell.Value
End If
Next
End Sub
Can someone help me with finding the value of the cel beside the selected cel in the combobox?