Linking 2 comboboxes Column A and Column F

[Excelnewbie001]

I have 2 comboboxes that I want to link Column A is Dates and Column F is the data. For instance when I click on combobox2 A2 it must show combobox3 F2 is value. I have tried the following code but it does not work -I have set the rowsources correctly as it shows both fields but when selecting it doesnt show the corresponding linked columns data. The data ONLY starts in A2 and F2. Form controlled comboboxes

This is the code I have. Any help appreciated.

ComboBox3.Value = Cells(ComboBox2.ListIndex + 1, 6)

 

[Excelnewbie001]

Column A is the date Column F is the sales for the day so A2 =F2 (Sales for the day)
Anyone please I need to get this combobox working.....its on a Userform thats linked to a sheet. The comboboxes are linked with the sheet rowsource on the combobox settings.....My problem is in this code

Private Sub ComboBox2_Change()
ComboBox3.Value = Cells(ComboBox2.ListIndex + 1, 6)
End Sub

 

[Excelnewbie001]

Fixed it myself....Rowsource property cannot start on A2 -Always 1 -changed the rowsource to 1 and the form control works now