LinkBack URL
About LinkBacks
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?
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?
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.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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?
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.
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!
Don't cave so early... Look at
http://www.techrepublic.com/blog/win...l-time-values/
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.
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
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,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks