View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Echo[_2_] Echo[_2_] is offline
external usenet poster
 
Posts: 7
Default problem with calendar dates format

I think I can help he

I messed around for a while and came up with this, which seems to work.

Private Sub CommandButton1_Click()
TextBox1.Value = Format(TextBox1.Value, "dd/mm/yyyy;@")
End Sub