Textbox format

Hi vba-lover

Try something like the below for textbox1 :

If TextBox1.Text = Format(TextBox1.Text, "dd-mm-yyyy") Then
'your code here
Else
'your code here
End If

for the Yes or No textbox I would use a combobox with Yes or No options, but if you do want to use a textbox try something like

If TextBox2.Text <> "Y" Then
    If TextBox2.Text <> "N" Then
    MsgBox "Please Enter Y or N"
    Else
    End If
End If

Let me know how you go!