Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form text box date problems
I Have a user form with a no. of text boxes
textbox 3 to 5 the user is required to enter a date in the numeric format 2 day characters then 2 month characters and then the year e.g. 10-09-2005 (ex1) or 15-09-2005 (ex2) I Have the following code attached to a button on the user form to do this. Worksheets("MainPage").range("C22").Value = Format(TextBox3.Text,_ "dd-mm-yyyy") Worksheets("Data Entry").range("B2").Value = Format(TextBox4.Text,_ "dd-mm-yyyy") Worksheets("Data Entry").range("B3").Value = Format(TextBox5.Text,_ "dd-mm-yyyy") The problem is the when a date is used such as ex1 above when the date gets to the worksheet the month and day part has been reversed. Also when you look at hte cell on the work sheet it has been formatted as 09/10/2005. Which is not the instruction in the format command. Any help you can provide would be appreciated. Regards Francis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with date in user form | New Users to Excel | |||
Date format changes when inputed from user form | Excel Discussion (Misc queries) | |||
how to format a date/validate for a text box entry on a user form | Excel Programming | |||
Date formatting issue in user form | Excel Programming | |||
User Form Text Box | Excel Programming |