Hi
I have a user input form made through vb which allows users to enter data in the form and then click a button and the data populates into the worksheet. This works fine except there is a text box field for a date. When the data is populated the date format comes out as mm/dd/yyyy in the worksheet. So when a user enter 10/01/1985 in the text box field it populates into the worksheets as 01/10/1985. Is there a way of changing the format so that it populates in the uk date format dd/mm/yyyy?

Hi David

Thankyou for your question

My first impression is that the format of the cells into which the date value is being entered is causing the problem.

If you select the cells in question and click on Format-Cells-Number you will see the date format options.

You should first ensure that the location is set to English(UK), not English(US) and then choose the specific format that you need.

If this doesn't solve the problem, please let me know so we can explore other options

Regards

Stephen

Thanks for the quick response Stephen. I have just tried this and it is still being populated in the format mm/dd/yyyy. I wonder whether in the vb code we have to specify the format?

Hi David

I have just tried to replicate your problem using the method you describe, and my dates come out in the correct format.

There are a number of VB expressions that allow dates to be formatted in a particular way, but it is difficult give you precise advice without seeing the problem first hand.

Is it possible for you to email me a copy of the workbook? My email address is stephenATmicrosofttraining.net

Regards

Stephen