Populate textbox from multiple combobox entries

[mdex]

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

[AlphaFrog]

Try using the Cells object instead of the Range object.

Please Login or Register  to view this content.

[mdex]

Try using the Cells object instead of the Range object.

Please Login or Register  to view this content.

Cheers AlphaFrog,

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

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