+ Reply to Thread
Results 1 to 2 of 2

Simple Userform Textbox Date Picker

  1. #1
    Registered User
    Join Date
    07-18-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    36

    Simple Userform Textbox Date Picker

    I have used this site extensively since joining and it has helped me numerous times. However, I really couldn't find anything to allow a simple date picker for a text box that didn't use another calendar control,etc. So I submit this as my contribution to the community. It guarantees the field value is a valid date once any key is pressed. Feedback welcome.

    The routine limits the keypresses accepted by the textbox to T,Y,R,M,H,-,+,=. The characters mimic Quicken/Intuit products for changing a date. They are the first and/or last letter of Today,YeaR, and MontH and + and - to increment/decrementing the Year, Month, or Day. It is easy to modify to allow other keys to be accepted, while still maintaining the inc/dec control.
    In userform:
    Please Login or Register  to view this content.
    In module:
    Please Login or Register  to view this content.
    Last edited by excel_joe; 01-22-2016 at 03:20 PM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Simple Userform Textbox Date Picker

    However, I really couldn't find anything to allow a simple date picker for a text box that didn't use another calendar control,etc.
    If you want a calendar control but don't want to use any of the built in controls, here's an alternative that work across all versions of Office.
    David
    (*) Reputation points appreciated.

+ 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. How can I use the date picker tool to populate a textbox in a userform
    By Mad Moose in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2015, 04:44 PM
  2. Add Date Picker To 2 Textbox In VBA UserForm2
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2014, 07:22 AM
  3. [SOLVED] Userform date picker - help required
    By nickhunt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2014, 03:39 PM
  4. Date picker UserForm to stay always in front of the main UserForm
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 07:31 AM
  5. [SOLVED] Date Picker in UserForm will not add value to specified cell
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2013, 01:18 PM
  6. Date picker on userform
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2011, 05:18 AM
  7. Date Picker won't select current date: Userform
    By valkok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2011, 06:09 PM

Tags for this Thread

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