Hello
The goal is: In a userform, a textbox to fill only with dates
I find to do the following stuff:
Sub UserForm1_Initialize()
TextBox1.Value=Format("the date","dd/mm/yyyy")
End Sub
The result must be that when UserForm1.SHow
the texbox looks like ../../....
and that you will only fill the textbox with date
I try with :
If IsNot Texbox1.Value=Format("...","dd/mm/yyyy" ) Then
MsgBox "Saisie invalide", vbCritical, "Attention"
or
In what direction I must search the solution?
I hope that what i have wrote is "limpide"