View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonov Antonov is offline
external usenet poster
 
Posts: 44
Default error in userform?

I have this userform. In some textboxes I need to input dates in a short
format (i.s. 01aug) The receiving cell in my worksheet has been correctely
formatted to display the date (01-aug-06). In fact when I input the date
without using the userform it works ok but when I do this using the userform
the display is exactely like the input (01aug). Any idea on how to fix this
problem?
This is the formula I use:

Sheets("AB").Cells(16, 12).Value = In.Text
Sheets("AB").Cells(18, 12).Value = Out.Text

When I use the program at home (in english) all works correctly, at the
office (italian) I get this problem.
Thanks for any help or suggestion