User Form field inserts wrong date format

**simjambra** · 03-26-2009, 05:58 AM

Hello there team.

I have cobbled together (borrowing from examples I have found online because I don't know VBA) a form which inserts a date into a spreadsheet.

The trouble I have is that this date field is in USA date format and I need UK.

If I enter 03/01/2009 into the form, it appears in the spreadsheet as 01/03/2009. I have formatted these cells to display the month only and because of the way it was entered, the next column displays MAR instead of JAN.

Any ideas?

Can I validate the input value in a form?

Thanks for all your help as usual, you guys rule!

**Greg M** · 03-26-2009, 06:35 AM

Hi there,

Working with dates can often be tricky! The following code (in the VBA code module of the userform) works for me:

Please Login or Register  to view this content.

If this doesn't do the trick, post your workbook (or a section of it) here and I'll take a look at it.

Regards,

Greg M

**antoka05** · 03-26-2009, 06:35 AM

If the date is in format dd/mm/yyyy you can try to use this code (here I suppose your data field in form is called 'Textbox1'):

Please Login or Register  to view this content.

Regards,
Antonio

**mudraker** · 03-26-2009, 06:46 AM

The date problem is something users who do not use the American date format have been having to deal with for years

See my reply in this old thread

http://www.excelforum.com/excel-prog...and-forms.html

There is also a little bit more in this thread

http://www.excelforum.com/excel-prog...-workbook.html

**simjambra** · 03-26-2009, 07:18 AM

Thank you for all your suggestions.

Here is a copy of the sheet I am using.

On the Feedback Summary sheet, if you click on the top button, a form appears. The feedback is recorded and then summarised on the other sheet.

The trouble is, I am now trying to work out how to summarise each category for each trainer PER MONTH so when the date goes in, incorrectly it's not gerating the correct date.

Mudraker, I couldn't see those hyperlinks but I will have a search.

Thanks

**Greg M** · 03-26-2009, 07:41 AM

Hi again,

The highlighted addition to your code seems to give the correct result on my system (Excel 2000):

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**simjambra** · 03-26-2009, 08:10 AM

Greg, that seems to work great.

Cheers mate

**Greg M** · 03-26-2009, 04:09 PM

Hi again,

Many thanks for your feedback - I'm very pleased that I was able to help.

Regards,

Greg M

User Form field inserts wrong date format

LinkBack

Thread Tools

Rate This Thread

Display

User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Re: User Form field inserts wrong date format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions