PDA

View Full Version : Date Format US/UK



steve.t
11-20-2007, 05:37 PM
For all those that have trouble with Date Formats being changed from UK format in a user form text box to US format in the destination cell on your worksheet :

See post "Solved: Date Saving Problem"

Use CDate

eg. ActiveCell.Value = CDate(txtDate.Value)

Good luck,

Steve T