Hi Bob

Yes, what im doing is via my user form invoking the auto filter on a different workbook and then filtering the date field and copying to a new workbook.

My textbox input is in the format dd/mm/yyyy

When i check my data the custom field on the autofilter swapps the dd/mm to mm/dd, i have found by formatting my text box as mm/dd/yyyy in my code solves the problem.

I was just wondering why it does that, my excel and PC are set up for UK dates?

Cheers

Gibbo