Hello Everybody,
The Date and time Picker 6.0 from microsoft is giving me a hard time. I have some data in an Excel 2003 sheet that I want to work with.
I can save a selected date from the date and time picker (on a form with lot's of other data) in to the sheet using: cells(4,4).value=Dtp1.value. No problem with the new created information.
Now I want to load the data from the excel sheet into the value of the Dtp1.vale.
It won't work, I Used Format(), I tried a date variable but It won't work
Wat am I doing Wrong,
Does enyone now the right way to give Dtp1 the date from the excel 2003 Sheet?
Hope to hear from you soon,
Harm
The Date and time Picker 6.0 from microsoft is giving me a hard time. I have some data in an Excel 2003 sheet that I want to work with.
I can save a selected date from the date and time picker (on a form with lot's of other data) in to the sheet using: cells(4,4).value=Dtp1.value. No problem with the new created information.
Now I want to load the data from the excel sheet into the value of the Dtp1.vale.
It won't work, I Used Format(), I tried a date variable but It won't work
Wat am I doing Wrong,
Does enyone now the right way to give Dtp1 the date from the excel 2003 Sheet?
Hope to hear from you soon,
Harm