I had been hating write the code about date & time format. There are a problem as following code, I had tried to using Cdate, DateValue, Val...but not work,anyone solve it. Thks.
Dim fmt As String
fmt = "hh:mm:ss yyyy/mm/dd"
.Enabled = True: .Value = Date...