Textbox value

R

ranswrt

I have a textbox on a userform to input dates. How do I format the textbox
to only accept dates in the form of mm/dd/yy?
Thanks
 
O

Office_Novice

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "mm/dd/yy")
End Sub
 
R

ranswrt

Works great
Thanks

Office_Novice said:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "mm/dd/yy")
End Sub
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Creating a Search using a combo box and then creating a report. 4
date entry in userform textbox 7
VB Date Format 8
date code 5
Pasting a date to a cell from UserForm 2
Optionbutton Not working 3

Top