Thank you very much for helping me again
In fact I tried to follow your steps and put the code in ComboBox3 change but don't know what x variable refer to?
I tried this but got an error
Private Sub ComboBox3_Change()
If Me.ComboBox3.ListCount <> 0 Then
'We stored the row number the data came from in combobox2 change.
'We'll use it to display the description.
Dim x As Long
x = Me.ComboBox3.List(Me.ComboBox3.ListIndex, 1)
If Range("C" & x) = ComboBox1 And Range("D" & x) = ComboBox2 Then
ComboBox3.AddItem (Range("E" & x))
ComboBox3.Column(1, ComboBox3.ListCount - 1) = x
End If
Me.TextBox_mycode = Cells(x, 6)
End If
End Sub
Can you post the whole code for me?
Thanks advanced for help
Bookmarks