+ Reply to Thread
Results 1 to 6 of 6

restricting date text box between certain dates

Hybrid View

  1. #1
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: restricting date text box between certain dates

    Why not use mindate property of datepicker control?
    If you are pleased with a member's answer then use the Star icon to rate it.

  2. #2
    Forum Contributor
    Join Date
    04-14-2013
    Location
    Ky
    MS-Off Ver
    Excel 2013
    Posts
    344

    Re: restricting date text box between certain dates

    Quote Originally Posted by buran View Post
    Why not use mindate property of datepicker control?
    I could try, but A) I didn't write the code for the date picker (downloaded from the internet) - too complex for my current skill level, and kind of afraid to mess too much with it; and B) still doesn't address the problem if the enduser types the date manually and does not use the date picker.

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: restricting date text box between certain dates

    I read your post for second time. Do you really use DatePicker control or you expect user to enter date in a TextBox control? Note that these are two different types of controls and if you are using textbox, then my suggestion is not correct.

  4. #4
    Forum Contributor
    Join Date
    04-14-2013
    Location
    Ky
    MS-Off Ver
    Excel 2013
    Posts
    344

    Re: restricting date text box between certain dates

    Quote Originally Posted by buran View Post
    I read your post for second time. Do you really use DatePicker control or you expect user to enter date in a TextBox control? Note that these are two different types of controls and if you are using textbox, then my suggestion is not correct.
    Perhaps I misspoke... I'm using a text box with a date picker form that the enduser has the option of using. I don't know for sure, but my guess is that about half of the users will type manually because its quicker than reaching for the mouse, but I suspect many of the slower typers and those not used to tabbing through a form will use the date picker form, activated by a small command button placed next to the date text box.

    My fault for not being too clear on that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Restricting format of date to text
    By sourabh1201 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-01-2013, 12:43 PM
  2. Restricting Specific Dates in any Given month
    By paxile2k in forum Excel General
    Replies: 11
    Last Post: 07-23-2009, 08:40 PM
  3. Restricting Text
    By nadiaz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2007, 04:25 PM
  4. Restricting copied text to one Column
    By Viking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2006, 09:30 AM
  5. Restricting Cell Entries to Text Only
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 03:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1