Excel Date Picker (Office 365)

I think you are out of luck. Microsoft "depreciated" this feature for 64 bit office. They decided that people really didn't want it.

However, I did find this https://www.contextures.com/exceldat....html#download - Select the cell where you want the date and click the button. I suppose you could also map the macro to a CTRL Key

The issue with this is application that you will have to integrate the code and the form into your workbook. It isn't that difficult to do. If you want, I can walk you through the process.

Can you save a file as XLSM or XLSB and record or add a macro? I can see where a truly paranoid organization won't let you do this. If you are allowed macros, then we still can proceed.

Were you able to download the file in the link and run the macro?

for all those that want a pop up calendar - set the type of format you require in the button class module - demo works from double click in columns A & B - set this range in worksheet module.
button may not be fully visible in some screen resolutions - however once again easy enough to tailor to your need by altering size on the simple userform.

thanks for the feedback and added rep point - glad to have helped.
you will find it easy to modify e.g. start week on a Monday or setting year range covered +/-

'TODAY' button added - extra code is annotated in the 'btnClass' module.

torachan:

Again, your sample XLSX works great. I now tried integrating the changes into my spreadsheet. I'm running into a "Run-time error 13".

Here's what I've done:
- Copied all code in the Btn class from your version/sample into my version.
- Renamed all instances of "Calender" to "Calendar" (this is the preferred American English convention). I worked ok w/ my earlier version w/o the Today button.
- Copied all VBA code from Sheet1 into my Sheet1 equivalent worksheet. Also replaced the single instance of "Calender" with "Calendar".
- Added new command button to my calendar and named it "cmdTODAY". Added "Today's Date" as its caption.

Here's what happening now:
- Everything works fine when picking a date from the calendar.
- However, when clicking on "Today's Date", it actually adds "Today's Date" into the cell (vs. 12/15/2022).
- At the same time, I get the run-time error.

Now, when clicking on "Debug", the line "ActiveCell = CDate(ActiveCell)" is highlighted in yellow.

My question: Did I miss adding some code from your latest sample file into my actual file?

did you rename the userform - sorry the spelling was accidently done in my very first app some years ago - I have kept it the same so that I know its many variations can be grafted into my apps without having to do a lot of editing.
its picking up the button caption and prefixing it to the date string because it is the last button in the group - you need to go through the entire code there is still an original name somewhere.
the name is irrelevant as long as it is the same throughout.

torachan:

It's working fine now... it really was a *crazy* reason as to why the Today command button didn't work in my actual spreadsheet.

Background:
- I compared all the code (your example) vs. my actual code. I could NOT locate any differences.
- Ultimately, I then copied my differently formatted calendar into your version and made the required adjustments (e.g., renaming the calendar objects, different RGB colors, etc.).
- It then worked fine.
- In the last step, I changed the command button's caption from "TODAY" to "Today". And BAM it then stopped working and I got the run time error again.

I would have never guessed that the line

Please Login or Register  to view this content.

is case sensitive. So, once I changed that line from "TODAY" to "Today", it then worked w/o issues. GREAT!!

Again, thanks!
Tom

glad you solved it - its the obvious simple bits that are not always obvious.

there has to be a question, why ? I can not understand the logic, I need to understand a reasoning for attempting the use of a totally inappropriate control.

you could use Labels and use the click_event alternatively have a look at Andy Popes site in the link below - I would have to think more deeply into intercepting the click_event on the shapes.
I would think it could be possible to use the image box - positioning the numbers (caption) may need more code than the internal property already available in the command button.
I like to see the boundaries explored - stretching the 'grey matter' - interested to see the outcome.
The attached works with very little code - but it has a lot of graphics.

https://andypope.info/vba/userformdraw.htm

id like to chime in and say this is the most amazing thing ever!
ive incorporated into a spreadsheet ive been working on.
The only question i have, is, what controls the location of the pop-up calendar?
EDIT: NM! Figured it out!

thank you so much guys!

Originally Posted by jpauleen

Hi, I am a complete Excel beginner and I have been looking for something like this for a while now! Only problem is, I don't know how to incorporate it into my workbook or even customize the calendar itself :/

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread