VBA Form is sumbitting dates as USA Format - I need UK format

[scottmcclean]

HI There,

I have created a VBA Userform in Excel which on the whole works great.

My problem is I am new to VBA and must be doing something wrong as I cannot fathom out how to get the form to submit a date in UK format. I can type a date into my Excel worsheet cell and it is correct, but when I use the form to "submit" into the same field it does so in USA format.

I am currently using a text box: Me.txtNextDate.Value which simply updates a field in the datasheet.

Is there a way to either globally control all of the dates to UK format, or is there a way to format the text field so that it populates the datasheet correctly in the UK format?

Many thanks in advance

Scott

[john55]

try this

Please Login or Register  to view this content.

[Norie]

Scott

Perhaps.

Please Login or Register  to view this content.

[jolivanes]

Would this happen to make a difference?

Please Login or Register  to view this content.

[scottmcclean]

Hi John,
Apologies for the delay in responding.

Where do I put this line of code? My current line of code which inserts the data is this: ".Cells(iRow, 4).Value = Me.txtLastUpdated.Value"

Many thanks

[john55]

perhaps

Please Login or Register  to view this content.

[scottmcclean]

Thanks John - it did the trick. Much appreciated.

cheers
Scott

[john55]

you're welcome!