A date picker userform for Mac.

[sophia.ho]

Thank you!

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.