ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform error? (https://www.excelbanter.com/excel-programming/372541-userform-error.html)

Antonov

userform error?
 
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?
Thanks



rub

userform error?
 
can you show the code.
antonov wrote:
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?
Thanks



Antonov

userform error?
 
I will go to the office tomorrow and pick up the program and will then post
the code
thanks for your reply
"rub" wrote in message
oups.com...
can you show the code.
antonov wrote:
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?
Thanks






All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com