Date formatting problem in Excel vba

[PaulC]

I have input the current date into column from macro using Date function. This column is formatted as dd/mm/yy.

I have then tried to input the values from this column into a textbox (txtEnteredOn) on a userform using to force the correct format:

Private Sub txtEnteredOn_Change()
txtEnteredOn = Format(txtEnteredOn.Value, "dd/mm/yy")
End Sub

However, the date shows as mm/dd/yy format.

How can I get it to show as dd/mm/yy format?

Paul

[sweep]

Hi,

have you got the variable dim'd as Date?

[PaulC]

Many thanks for suggestion - In the end I found if I added formatting to the value added to the textbox - ie:

DepmuDetails.txtEnteredOn.Value = Format(EnteredOnDate, "dd/mm/yy")

it did the trick,

Paul