I have the following code in UserForm_Initialize()
TextBox1.Value = Date
When I ran the form, the date shown was something like 04-Jul-11.
How do I have the date shown as dd/mm/yyyy or dd-mm-yyyy? In the above example, I would like the date to appear as 04-07-2011.
TextBox1.Value = Date
When I ran the form, the date shown was something like 04-Jul-11.
How do I have the date shown as dd/mm/yyyy or dd-mm-yyyy? In the above example, I would like the date to appear as 04-07-2011.