macro with Date and time picker

[Linde]

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

 

[Leith Ross]

Hello Linde,

I created a UserForm with a DTPicker and a command button. he command button sets the DTPicker to the value in cell "A1" of the ActiveSheet. The code checks if the value is a date before setting the DTPicker control.

Private Sub CommandButton1_Click()

    With Range("A1")
      If IsDate(.Value) Then DTPicker1.Value = .Value
    End With
    
End Sub

Sincerely,
Leith Ross

 

[Linde]

Hi everyone,

I installed an other version of the date and time picker.
I'm able to change the value of the object. But if I want to manauly adjust the date it keeps it's value.

I Don't understand,
Does enyone have these experience?

Harm

 

[Norie]

Try using DateValue to convert the value in the cell to a 'real' date - it might not be being recognised as one.

That could be because of formatting or other things.