Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
rub rub is offline
external usenet poster
 
Posts: 21
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform Error Steve B Excel Discussion (Misc queries) 2 February 6th 07 04:26 PM
userform error peter Excel Programming 0 May 1st 06 10:47 PM
error in userform damorrison Excel Discussion (Misc queries) 6 April 23rd 06 03:18 PM
userform error Kevin Lehrbass Excel Programming 1 January 20th 06 11:43 AM
userform error reuben Excel Programming 2 November 2nd 05 06:26 AM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"