Fill the right cell.

[Belleke]

I have a userform with 1 combobox and 2 textboxes.
In column A I have names from A3 down, in row 2 from B2 to the left I have dates.
I am trying to find a code that looks at the combobox value (name) and the textBox1 value (date) an than fills the correct cell with the value of textbox 2
for example The combobox.value (name) is in A4 and the textbox1 value (date) is in E2 then the textbox2 value has to go in cell E4
thanks in advance.
See example.

 

[Chihiro]

Something like below.

Private Sub Cmd_00_Click()
Dim c As Range

Set c = Range("2:2").Find(T_00.Value, Lookat:=xlWhole, LookIn:=xlValues)

If Not c Is Nothing Then
    Cells(C_00.ListIndex + 3, c.Column).Value = T_01.Value
Else
    MsgBox "Please enter valid date"
End If
End Sub

 

[Belleke]

Thank you Chiihiro, works like a charm.
Problem solved