Thread: Damn Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robzrob[_2_] robzrob[_2_] is offline
external usenet poster
 
Posts: 17
Default Damn Dates

I've got this code line: || Worksheets("Leave").Range("B6").Value =
UserForm1.TextBox2.Value || to prompt the user for a date which will
be input in UK mode and which I want to appear in B6 in UK mode, ie dd/
mm/yy. It's putting it in B6 ok, but wrongly, eg if I type in
10/08/09 (10 AUG 09), 08/10/09 appears in B6.