Populate textbox from multiple combobox entries

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.