Another Userform question.

  • Thread starter Thread starter ingleg
  • Start date Start date
I

ingleg

I have a textbox on a userform in which the date is entered, in dd/mm/y
format.

When it is shown in a cell in the spreadsheet, it shows as mm/dd/yy.

Is there anyway of getting it to appear in the cell as typed?

I have tried to change the formatting but this does not work
 
When a user types 01/02/03, do they mean Jan 2, 2003 or Feb 1, 2003 or....

Entering dates in an ambiguous format can sometimes result in the wrong dates.

You may want to drop the textbox and use a calendar control:

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm


Or use three different controls (one for the month, day and year) to get the
date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formatting from user form to worksheet 6
visual basic user form date format dd/mm/yy not mm/dd/yy 1
Format Date ComboBox 4
date format 1
Excel 2002: How to make the date format uniform ? 1
Preserving date format 1
How do I delete merged cells in Excel without deleting the final d 5
Conditional formatting of date-cell - 2007 5

Back
Top