Value of selected item in Combobox

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:

Please Login or Register  to view this content.

Can someone help me with finding the value of the cel beside the selected cel in the combobox?

Boris88,

Welcome to the forum. Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Thank you, it's working now!