+ Reply to Thread
Results 1 to 2 of 2

Form Text Box Date Picker

  1. #1
    Registered User
    Join Date
    06-11-2018
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Unhappy Form Text Box Date Picker

    Hey All,

    I am new to VBA and currently making a form in excel for data entry. The problem I have is that I have a lot of text boxs that require dates entered and I would like it when you click on a text box a calendar will appear so the date can be selected.

    I am using office 2016 and where this spreadsheet is going to be used I cant be installing the calendar extensions for excel.

    I have been looking at Trevor Eyre's Excel VBA Date Picker but I cant seem to get it to work in a text box.

    Any help or advice would be great.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,554

    Re: Form Text Box Date Picker

    Here is my version of a VA date picker. My examples show how to use it in a worksheet, or use in a UserForm using a label. I do not recommend using a textbox because allowing the user to also type into the textbox means you have to validate the user entry.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Add Date to User Form Without Access to Add Date Picker Control
    By kaleonard08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2016, 12:06 PM
  2. Using a Date time picker in a VBA form
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-18-2011, 07:41 AM
  3. Set up Excel Form with Pop-up Date Picker
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2010, 01:47 PM
  4. Date Picker from user form
    By Denzil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-07-2008, 04:28 AM
  5. Date Time Picker in User Form
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2006, 01:07 PM
  6. Using a Date time picker in a VBA form
    By tysop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2006, 10:25 AM
  7. [SOLVED] Form Date picker
    By Rob Hargreaves in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2005, 02:06 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