![]() |
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 |
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