Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default UserForm Date Validation

Hello Everyone,

Has somebody already comeup with a Date Validation VBA routine from an
TextBox entry from a UserForm??? If so, could you pass it along???

Thanks.. mv


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default UserForm Date Validation

if isdate(textbox1) then

beyond that, you would have to design it to check for you specific
specifications.

--
Regards,
Tom Ogilvy


"Michael Vaughan" wrote in message
...
Hello Everyone,

Has somebody already comeup with a Date Validation VBA routine from an
TextBox entry from a UserForm??? If so, could you pass it along???

Thanks.. mv




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 280
Default UserForm Date Validation

Suggestion: Consider Microsoft Date and Time Picker Control, MSCOMCT2.OCX?

"Michael Vaughan" wrote in message
...

Hello Everyone,

Has somebody already comeup with a Date Validation VBA routine from an
TextBox entry from a UserForm??? If so, could you pass it along???

Thanks.. mv




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
putting validation to TextBox in the userform salihyil[_6_] Excel Programming 1 February 26th 04 12:10 PM
putting validation to TextBox in the userform salihyil[_8_] Excel Programming 1 February 26th 04 10:59 AM
Userform Validation Todd Huttenstine[_2_] Excel Programming 2 December 13th 03 10:46 PM
Userform Date validation David Goodall Excel Programming 6 August 19th 03 11:46 PM
Userform Textbox in Password Validation golf4 Excel Programming 3 July 28th 03 02:27 PM


All times are GMT +1. The time now is 05:03 AM.

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

About Us

"It's about Microsoft Excel"