View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dianne Dianne is offline
external usenet poster
 
Posts: 107
Default VBA Date Function formatting

TextBox1.Value = Format(Date, "dd/mm/yy")

--
Dianne

In ,
David typed:

I am using the Date function to return the current date to
a text box on a user form. It arrives in "mm/dd/yyyy"
format.
How do I change the format, eg: "dd/mm/yy"?
David