i created a userform in excel where users input a date in textbox using calendar12.0 activex control.this calender in userform aswell with ok button.first user select a date then click ok button to copy date value in textbox. date is showing alright if date is >12 but if dat is <12 its showing it as month and showing month as day. example if i select (20 may 2013) it will show 20/05/2013.but if i select (9 may 2013) it will show (05/09/2013).textbox date format is dd/mm/yyyy...any thing i can do to solve this problem. thnx in advance