Excel VBA UserForm TextBox - How to format date 

Excel VBA UserForm TextBox - Learn how to format date
The code used in this video:
Private Sub UserForm_Initialize()
'txtDate.Text = Format(Now(), "Short Date")
'txtDate.Text = Format(Now(), "Long Date")
'txtDate.Text = Format(Now(), "mm/dd/yyyy")
'txtDate.Text = Format(Now(), "dd mmm, yyyy")
txtDate.Text = Format(Now(), "mmmm")
End Sub