Textbox format

[vba-lover]

Dear Experts

There are two textboxes in userform.

I want textbox1 to accept only Date value in format "dd-mm-yy"
Textbox2 should accept only logical vaue "Y" or "N"

Please help

[Steel Monkey]

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!