Hi All,

I am in serious and urgent need of answer to my problem.

I have built a user form in Excel 2007 which has a calendar and a textbox on it. When i click the date on the calendar it enters the date into the textbox, however the date is in mm/dd/yyyy fornat which is no good to me. Can anyone please tell me how i can get the date in the textbox to display dd/mm/yyyy?

Remember the date goes directly from the calendar to the textbox, no spreadsheet input wanted/needed.

Thanks

Si