ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Date Function formatting (https://www.excelbanter.com/excel-programming/281555-vba-date-function-formatting.html)

David

VBA Date Function formatting
 
Greetings,
TIA for any help
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

Dianne

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





All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com