+ Reply to Thread
Results 1 to 9 of 9

Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picker?

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Perth, Australia
    MS-Off Ver
    Office 2003, Office 2010 & Office 2013
    Posts
    4

    Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picker?

    I have done the rounds of the boards and it would appear there are no date pickers for Excel 2013 64 bit.

    Anyone built one or prepared to help a very basic VBA programmer write one?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    Hi Big_Ash and welcome to the forum,

    Leith Ross gave an great example of one a few months ago. See it attached. This might be exactly what you want.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    08-29-2014
    Location
    Perth, Australia
    MS-Off Ver
    Office 2003, Office 2010 & Office 2013
    Posts
    4

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    Hey Marvin, thanks heaps for the quick reply and it does work on my system, hallelujah!

    Would it be stretching the friendship to ask whether you know how to add this macro to the right-click menu?

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    Hi,

    It looks like this site explains what you want.
    http://www.ozgrid.com/VBA/right-click.htm

    It is a lot easier to add it to the Quick Access Toolbar (QAT) or put it on a double click event for a cell.

  5. #5
    Registered User
    Join Date
    11-01-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    Folks - I love this button idea for the pop up calendar and would like to know if it could be tweaked to add a "pick time" function for the date chosen. The times would be in 1/4hr or 1/2hr increments. It may exist but after a few hours I caved and came here for help! Thank for the help in advance. The perfect solution for my time card entries would have the user select the cell, then via dropdown or calendar button like this, choose a date and time. End result in the cell would be [4/13/2015 09:30:00 AM]

    Cheers!

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke


  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    smartin5, although your question is somewhat related to this thread we prefer that you start a new thread with your own question.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  8. #8
    Registered User
    Join Date
    03-08-2017
    Location
    Victoria, Canada
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    I am trying to return a date to a non-modal form, but because the form is non-modal once I leave the form to go to the date picker form it loses its place. The users want to be able to access other workbooks while my form is running which is why it is non modal. Is there a work around for this? My main form is called frmMain

    I tried toggling the frmMain ShowModal property as part of the GetDate routine but it doesn't work
    Please Login or Register  to view this content.
    Last edited by Don Hinz; 03-13-2017 at 04:56 PM. Reason: added code tags for new member

  9. #9
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Excel 2013 64 Bit - Does any one have some code or an add-in for a calendar date picke

    Don Hinz, as a new member please take the time to review our rules. There aren't many, and they are all important.

    First, we require CODE tags around all code to preserve spacing and readability. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Second, we request that if you have a new question, you start a new thread. Your question is not really about the original question in this thread, so please go to the VBA forum and post your question there. Thanks,

+ 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. Date Picker / Calendar for Combobox
    By sthiru in forum Excel General
    Replies: 9
    Last Post: 11-24-2015, 04:30 PM
  2. How to add a date picker / Calendar from clicking a cell
    By RichardJSigKits in forum Excel General
    Replies: 6
    Last Post: 02-09-2013, 12:52 PM
  3. DT Picker in excel 2013
    By mdshotgun in forum Excel General
    Replies: 0
    Last Post: 12-15-2012, 06:08 PM
  4. Use Calendar (Excel 2007) and the Date Picker (Excel 2010) in same project...
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2011, 01:52 AM
  5. [SOLVED] mscmctl2.ocx ... calendar and date picker sometimes not available
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2005, 08:05 AM

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