Hi,
I'm trying to only display the selected date (that i've selected in my DTPICKER1 calander userform), but it's also displaying todays time (in hours) directly after the date. Does anyone know how to format it correctly as when I try to it doesn't work.
tks
I'm trying to only display the selected date (that i've selected in my DTPICKER1 calander userform), but it's also displaying todays time (in hours) directly after the date. Does anyone know how to format it correctly as when I try to it doesn't work.
Code:
Private Sub UserForm_Activate()
EnterHours.DTPicker1.Value = Format(Date, "dddd, d mmmm yyyy")
Me.Label3.Caption = "I " & EnterHours.EmployeeNameBox.Text & " will deposit " & EnterHours.HoursDepositBox.Text & " for " & EnterHours.DTPicker1.Value
End Sub
tks