Format issue in UserForm interface

[Paul Sansom]

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

 

[VoG]

Try something like

Range("ControlSourse").Value = DateValue(TextBox1.Value)