yes, would work, but was hoping there was a masking solution... thanks

"Norie" wrote:


Santiago

As far as I know you can't use/create input masks in Excel

Can't you just check a date has been entered in the textbox Exit
event?

Code:
--------------------

Private Sub Textbox1_Exit(Cancel As Boolean)
If Not IsDate(Textbox1.Value) Then
Msgbox "Please enter a date."
Cancel = True
End If
End Sub

--------------------


--
Norie
------------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...o&userid=19362
View this thread: http://www.excelforum.com/showthread...hreadid=376862