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:
Can someone help me with finding the value of the cel beside the selected cel in 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
Bookmarks