Textbox format

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

Hi vba-lover

Try something like the below for textbox1 :

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Let me know how you go!