Good day,
I can't wrap my head around this issue. I have a userform with the following code: 

Private Sub UserForm_Initialize()
    Caption = "Selection"
    Me.ComboBox1.Clear
    LastRow = Worksheets("Standart Control").Range("A2").End(xlDown).Row
    ComboBox1.List = Worksheets("Standart Control").Range("A2:A" & LastRow).Value
End Sub
I need to add the following and thought it would be easy but can't figure it out...On my Worksheets("Standart Control") I have 2 column, both starting at A2 and the other B2. The two rows are meant to be together. One row is for my titles and each titles as a code beside them.

I have a TextBox3 in my userform right beside my combobox. I need that when I select the desired text from my combobox to add the code TextBox3 so if A6 in my is selected the B6 must show in my TextBox3. The reason I do not do a Range is because in my sheet I will always have additional information to add to this column.

Also I need it to be vice versa... If the code is in my TextBox3 then to populate the info in my Combobox1...


Could someone help me?

Excelnoub