Userform to check 2 textboxes for duplicate & date check

Hi,
Thanks in advance. I am new to VBA and so I need help of this forum experts to help me with 2 things in a userform.

I have a userform all set and ready to use but I'm facing a problem with it. The problem is I want the submit button to check if the entry has already been made by checking 2 textboxes (Textbox1 & Textbox2) with the columns in sheet (Column A & D). If both the textboxes' enry matches with the existing data then it should replace the row after giving a message else add it to next empty row. I used one code I got from this forum but it didnot work for me nor does it gives an option of replacing existing row with same data and I don't know how to modify it ..

There is one more thing I want the xperts help with that is I want to check the date entered in textbox2 if its previous then give error message (Basically it should not allow entry in previous date). I do have the code for this one but it is rejecting all dates of 2015 (I guess its taking format as mm/dd/yy however it should be dd/mm/yy.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I checked entire forum all I got was check duplicate only with 1 textbox. Any help will be appreciated. Thanks

Thanks Arkadi it did work... Could you please also help me with the duplicate check solution... I'm working on it for last 2 days and couldn't find any solution...