Hello I'm try to get from the user the date and time at the same datepicker so I try to do 21/06/2019 23:38 this format(dd/MM/yyyy hh:mm)
I use with Microsoft Date and Time Picker control version 6.0
[VBA]
public Sub bTNOK_Click()
Cells(1,1).Value = Format(DTPicker1.Value, "dd/MM/yyyy hh:mm")
End Sub
public Sub UserForm_Initialize()
With DTPicker1
.Format = dtpCustom
.CustomFormat = "dd/MM/yyyy hh:mm"
End With
End Sub [/VBA]
on the properties of datepicker
CustomFormat ["dd/MM/yyyy hh:mm"]
Format [3 - dtpCustom)
Value [21/06/2019]
when I run this the Value of cell 1,1 is "30/12/1889 00:00" so how can I fix it?