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