• Home
 · 
• Miscellaneous
 · 
• format a date to MM-DD-YYYY when entering any date in a texbox.

format a date to MM-DD-YYYY when entering any date in a texbox.

format a date to "MM-DD-YYYY" when entering any date in a texbox.

Rate format a date to MM-DD-YYYY when entering any date in a texbox.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

'use one command button, call it cmdFormatDate
Private Sub cmdFormatDate_Click()
'format date
txtDate.Text = Format(txtDate.Text, "MM-DD-YYYY", vbSunday, vbFirstJan1)
End Sub