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
See post "Solved: Date Saving Problem"
Use CDate
eg. ActiveCell.Value = CDate(txtDate.Value)
Good luck,
Steve T