regex to validate the date DD/MM/YYYY format

[Sagar0650]

i want to validate date taken from textbox(excel forms) using regular expression & if it is wrong it should popup msg to enter correct date format
date format is DD/MM/YYYY

 

[Norie]

Do you really need to use a regular expression?

Couldn't you use IsDate to check a valid date has been entered and if so format it as required?

 

[Sagar0650]

i am not sure if that will work.
if you can help me with isdate, it will be great
Thank you

 

[Norie]

Something like this perhaps

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

    With Me.TextBox1
         If IsDate(.Value) Then
             .Value = Format(DateValue(.Value, "dd/mm/yyyy")
         Else
             MsgBox "Please enter a valid date.", vbInformation,  "Invalid date"
             Cancel = True
        End If
    End With

End Sub

 

[Sagar0650]

when i am clicking in the textbox, i am getting a function as private sub textbox1_change()
you have mentioned as textbox1_exit()
sorry for bothering you again
i am kind of new to vba

 

[Norie]

I'm assuming the textbox is on a userform.

If it is when you double click it you will see the Change event but you should also be able to select it's other events e.g. Exit from the right hand dropdown above the code window.

 

[Sagar0650]

yes the textbox is on userform

If it is when you double click it you will see the Change event but you should also be able to select it's other events e.g. Exit from the right hand dropdown above the code window.

you want me to change any property of textbox from the property window?

 

[Norie]

No, but it would be good to know where the textbox is located.

Is it on a userform or a worksheet?

 

[Sagar0650]

It is on userform
To be more specific useform3

 

[Sagar0650]

can you please suggest?
Thank you for support