Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with calendar dates format
i have a calendar from which a user selects the date, which is the displayed in a text box. The problem is that the date displayed in th textbox is in the format mm/dd/yyyy, when i want it to be dd/mm/yyyy ive tried a few things but cannot get it to display the date correctly here is my code: Private Sub Calendar1_Click() TextBox2 = Calendar1.Value TextBox2 = Format(TextBox2, "dd/mm/yyyy") End Sub my regional setting is set to english (UK). the properties on the calendar shows the values on the calendar a dd/mm/yyyy. But when i run the macro, the text box shows i differently. Also after trying to convert the format in the text box, it half works by this i mean if i select the 24 of june 2006, it displays it a 24/06/2006, which is cool, but if i select 8th of june 2006, then i displays it as 6/8/2006, which is messed up. how can i get this to work?? any ideas? pls help if u can thank -- s_ali_hassa ----------------------------------------------------------------------- s_ali_hassan's Profile: http://www.excelforum.com/member.php...fo&userid=3532 View this thread: http://www.excelforum.com/showthread.php?threadid=55724 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import excel 2003 dates & notes to Julian calendar format? | Excel Worksheet Functions | |||
Calendar List to Calendar format | Excel Worksheet Functions | |||
Conditional Format matching Dates,calendar | Excel Discussion (Misc queries) | |||
Date problem when opening a csv with dates in dd-mm-yyyy format. | Excel Programming | |||
list of dates to calendar format | Excel Programming |