ee_lcpaa
asked on
Set DateTime format for a SEP Date Control Object
Dear all,
I am using the SEP Date Control Object in Excel.
How to set the datetime format to be "dd/mm/yyyy". I cannot set it in the control properties dialog box.
Please advise how it can be done in VBA.
Thanks.
I am using the SEP Date Control Object in Excel.
How to set the datetime format to be "dd/mm/yyyy". I cannot set it in the control properties dialog box.
Please advise how it can be done in VBA.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me.ControlName = Format(Date, "dd/mm/yyyy")