Search and Update Records in User Form changing dates to US Format in Spreadsheet

[JTResearch]

I have a problem with the date format in a user form that is searching and updating existing records.

I am using the following code for a "search and update" form. The user enters dates in UK format (dd/mm/yyyy) but they are displaying in the data sheet in US format (mm/dd/yyyy) which is causing problems. In my other "add record" form I have used CDATE but can't work out how to do it in the "search and update" form.

I have NO VBA experience and have did a simple cut and paste to get this code from the internet so am not quite sure how I have made it this far!!

Please Login or Register  to view this content.

[AlphaFrog]

Try this (not tested).

Please Login or Register  to view this content.

[JTResearch]

Thank you so much AlphaFrog. This works and I have added a the new line for each coloumn with a date. I now have another problem with my add form but will post seperately. Thanks again.

[AlphaFrog]

You're welcome.