Dates in Forms

[iambalrog]

Hi All You Wise Genius'!

I have built a macro that asks users to input details of projects they have completed - the macro then stores this information in another spreadsheet and plays with it a bit.
Two of the fields i ask the user to populate are the start date, and end date of their time on the project.

however being an absolute programming schoolboy, i cant make the dates they put in come out in english formatting (i.e. the 6th march 2006 entered as 06/03/06 comes out as american as 03/06/06)

There must be an easy solution!

Thanks

[stevebriz]

Eg:

Output= Format(Textbox1.value,"dd mmmm YYYY")
MsgBox Output