| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox value
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox value
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "mm/dd/yy") End Sub "ranswrt" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox value
Works great
Thanks "Office_Novice" wrote: Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Value = Format(TextBox1.Value, "mm/dd/yy") End Sub "ranswrt" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight all Text in a Textbox when the textbox is selected | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Linear Mode
