date format in user form and excel show different format.

[ellyna]

Does anyone could help me ? The date format appear differently. Does my vba code script wrongly?

[vba code]
Private Sub UserForm_Initialize()
txtDate.Text = Format(Date, "dd/mm/yyyy")
Call Reset
End Sub

 

[Norie]

Can you post the code that's putting the value from the textbox in the cell?

 

[ellyna]

Can you post the code that's putting the value from the textbox in the cell?

This is the code. As the time is automatically when we open the user form.

[vba code]
Private Sub UserForm_Initialize()
txtDate.Text = Format(Date, "dd/mm/yyyy")
Call Reset
End Sub

 

[Norie]

That's the code to put the current date in the textbox and as far as I can see its formatted as you specified in the Format function.