how to debug.print datepicker value

[Pookiemeister]

As the title states, how do I get the value of the date picker by debug.print.

Thank you

 

[bobsan42]

Private Sub DTPicker1_Change()
    Debug.Print "Date selected: " & DTPicker1.Value
End Sub

put this in the code module of the parent object (a Sheet or an UserForm) of the DTPicker and adjust the picker object name.
The result of the code can be found in the Immediate window of VBE (alt+F11 -> Ctrl+G)

 

[Pookiemeister]

Now I am wondering? Is it possible to format a DTPicker value without the forward slashes? i.e. 03122019 or 3122019. Thank You.

 

[bobsan42]

Private Sub DTPicker1_Change()
    Debug.Print "Date selected: " & Format(DTPicker1.Value, "ddmmyyyy")
End Sub