I have a Userform with a DTPicker control. When I load the form, I store the date from cell E9 in the DTPicker Control. Then I have a command button to send the value from the control back to E9. However, when I send it back, i get "12:00:00 AM"
My format for the cell is set to Short Date and my format for the DTPicker control is "1-dtpShortDate"
The date loads to the control in the form fine...Any ideas? The below is the code that sends the value to the cell, where "budget_start" is the name of the control. I also tried formatting the budget_start.value in the expression below, no luck
![]()
Range("budget_start").Value = budget_start.Value
Bookmarks