Paul Sansom
Board Regular
- Joined
- Jan 28, 2013
- Messages
- 178
- Office Version
- 2021
- 2016
- Platform
- Windows
Hi
I have Userform containing several textbox.
TextBox11 is my date capture input and takes the input value from user and puts it into a defined cell (ControlSourse) "Enter_Date_Created"
The problem is that the input always revert to US date format.
The ControlSource cell is currently formatted to Date but i have tried General.
The workbook defaults are UK.
Is there a way to control and force the Textbox format in the VBA code to display in date UK format as I cant see any way to control it via the VBA properties.
Really bugging me now
Paul
I have Userform containing several textbox.
TextBox11 is my date capture input and takes the input value from user and puts it into a defined cell (ControlSourse) "Enter_Date_Created"
The problem is that the input always revert to US date format.
The ControlSource cell is currently formatted to Date but i have tried General.
The workbook defaults are UK.
Is there a way to control and force the Textbox format in the VBA code to display in date UK format as I cant see any way to control it via the VBA properties.
Really bugging me now
Paul