On my userform I have a box where t

[Navvy]

On my userform I have a box where the user has to enter a date in the following format:

dd/mm/yy

Is there any way to prompt the user to type in the date in that format, i.e. --/--/-- where the user can only type over the "--"?

 

[ssVBAdev]

I would allow the user to enter the date as they normally would (I know people tend to do this differently) and then format the date as I need in the code:


Private Sub txtTextBox_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
txtTextBox.Value = Format(txtTextBox.Value, "dd/mm/yy&quot
End Sub


********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!