Populate textbox from multiple combobox entries

I have a table of dates, stores and contacts for a lookup of who to call on what day.

Date Store1 Store2 Store3
07/10 Bob John Gary
08/10 Bob Ryan Gary
09/10 Mike Phil Ian

I'd like to have 2 combo boxes, 1 listing the dates and the other listing the stores with a text box returning the name of who to call.

I can get it to work to a point if I specify the column to check but can't figure out how to specify the range using the 2nd combo box.

Private Sub ComboBox1_Change()
TextBox1.Value = Range("B" & ComboBox1.ListIndex + 1)
End Sub

As a side not my Combobox shows the dates correctly as '07/10/2014' until selected which then showing as a general number '41919'

Cheers

Originally Posted by AlphaFrog

Try using the Cells object instead of the Range object.

Private Sub ComboBox1_Change()
    If ComboBox1.ListIndex > -1 And ComboBox2.ListIndex > -1 Then
        TextBox1.Value = Cells(ComboBox1.ListIndex + 1, ComboBox2.ListIndex + 1)
    Else
        TextBox1.Value = ""
    End If
End Sub

Cheers AlphaFrog,

With just a little tweak changing to +2 it works perfectly.

I'll have a play with the date function now.