Problem with Userform 'Calendar to textbook' Date Format

[TitusandNero]

Hello there,
Can someone help me please? I'm operating on Excel 2007 and using Calendar Control 11.0. I have textbox (tbDJ1) on a userform (CaseManagementSystem) and next to it is a command button. Click on the command button and it shows a calendar on a separate userform (Calendar), click on a date and it populates the text box. However, the format of the date when it populates the textbook is mm/dd/yy and I need it in dd/mm/yy. Is there a way to change this? Here is my code which is on the Calendar userform:

Private Sub Calendar1_Click()
CaseManagementSystem.tbDJ1 = Calendar1.Value
End Sub

Any help would be much appreciated. Thank you.

 

[Leith Ross]

Hello TitusandNero,

Try this...

Private Sub Calendar1_Click()
     CaseManagementSystem.tbDJ1 = Format(Calendar1.Value, "short date")
End Sub

 

[TitusandNero]

Hi Leith - thank you but unfortunately it doesn't seem to like the comma after Value. Turns red and returns a pop up saying 'Compile Error: Expected: end of statement'

 

[TitusandNero]

DUH!! I take that back - I left out the FORMAT bit - Superb! It works perfectly. Thank you so much it was driving me bonkers.

 

[Leith Ross]

Hello TitusandNero,

When that happens to me, i either drink more coffee or try to get more sleep. That usually fixes the problem.

Glad you got it working.