Date Format -USA to UK in Userform

Is there anyway of getting a userform to send the date out in UK format rather than American?

I have read many posts on it this afternoon and cant get any to work for my user form.

The database which the user form sends to cannot be changed.

Regards BVG

Hard to say as you do not provide much info.

But have you tried formatting the value, something like,

Format(Date,"dd/mm/yyyy")

Try,

ws.Cells(iRow, 3).Value = DateValue(Me.txtDateIntoStock.Value)

It replaces the existing code you have in the cmdAdd click event.

It does require the date to be entered in uk format.

You would avoid a lot of confusion if you used dd/mmm/yyyy on the userform.

It does require the date to be entered in uk format.

I must add to this that it bwill take any format specified by your regional setting (Windows settings)

Even "2012, Dec, 31" will be OK.

If you would like to force dd/mm/yy you'll have to make a full routine to check. You can make a suggestion (for the users) by adding this:

Private Sub UserForm_Initialize()
  Me.txtDateIntoStock.Text = Format(Now, "dd/mm/yy")
End Sub

Datevalue itself will transform the STRING into a Excel date type (number of days starting from 00/01/1900)