Thank you!

Quote Originally Posted by mikerickson View Post
It should work from another userform.

I'm at work and can't test, but I would create a userform, with a command button, a text box and this code and see what happens.
Private Sub CommandButton1_Click()
    Dim uiDate As String
    
    uiDate = macDate.Chosen
    
    If uiDate = False Then
        MsgBox "canceled"
    Else
        TextBox1.Text = Format(uiDate, "mm/dd/yyyy")
End Sub
The userform that is the date picker must be named macDate.