when using input box mydate and i try to put the date into the active cell it
changes from dd/mm/yyyy to mm/dd/yyyy how can stop this. Code follows

mydate = InputBox("Enter date as dd/mm/yyyy or Cancel to edit", Date, Date)
activecell=mydate