Make Dtpicker and combobox the same date

[Excelnewbie001]

Need some help from the excel gurus. How would I get that I get my Combobox2 and DTPicker3 have the same date with otherwords if I select the date in the combobox make it automatically select the date on the Datepicker DTPicker3

I tried this but it doesnt work

DTPicker3.Value =Combobox2.Value

My format on my date and my Combobox are the same in this format 17/11/16 -YY/MM/DD. Should I set this on the form initialize or on the DTPicker change ?

Thank you for any help .....

 

[Norie]

Which version of Excel are you using and how did you create the datepicker?

 

[MrIfOnly]

Your code as written should work. I would put it in the Combobox2_Change event.

 

[Excelnewbie001]

Which version of Excel are you using and how did you create the datepicker?

2010 its a standard datepicker

 

[Excelnewbie001]

Your code as written should work. I would put it in the Combobox2_Change event.

I also thought so I am getting runtime error 380 ......my date in my combo box display a serial and not a date and I think thats my problem -help please 43023

 

[MrIfOnly]

......my date in my combo box display a serial and not a date and I think thats my problem

Ahhh....this is contrary to your first post. Try this:

DTPicker3.Value = Format(ComboBox2.Value, "yy/mm/dd")

 

[Excelnewbie001]

Ahhh....this is contrary to your first post. Try this:

DTPicker3.Value = Format(ComboBox2.Value, "yy/mm/dd")

This changes to the datepicker date....perfectly but I am thinking I have another problem if I select the combobox it displays dates correctly but when I am choosing 1 day...then the day changes to a serial number MrIfOnly

Thanks for your help

 

[MrIfOnly]

How are you populating the combobox?

 

[Excelnewbie001]

How are you populating the combobox?

Private Sub ComboBox2_Change()
Sheets("TEST2").Activate

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

DTPicker3.Value = Format(ComboBox2.Value, "yy/mm/dd")

End Sub

 

[MrIfOnly]

Is combobox2 a list of dates? How is that combobox populated?

I think this might be easier if you can upload your file to a file sharing site and post the link here so I can take a look.

If that's not doable then please post the code that shows how you populate combobox2.