How do I make my Excel calendar pop up? - Excel Tips and Tricks

Discover how do you make an excel calendar pop up?Another way to ask is how do I create a date picker in VBA? Some people like to ask is how to use Datepicker in VBA Excel? Another way, how do I make a date picker on Excel VBA? Or how do I open a date picker in VBA?

These are the steps outlined the video.

Enable Developer Tab
1) Right-click anywhere in the ribbon
2) Customized the Ribbon...
3) Check on Developer
4) OK

Add Mini Calendar
1) Developer ~ Add-ins
2) Store
3) Search for date
4) Select "Mini Calendar and Date Picker".
5) Add
6) Continue
7) Size the mini calendar.

Assign object name to Mini Calendar
1) Home ~ Editing ~ Find & Select ~ Selection Pane...
2) Give the mini calendar a name of "calendar"
3) Enter
4) Close "Selection Pane"

Add VBA to Hide/Show Mini Calendar
1) Right-click sheet. View Code.
2) Select Worksheet
3) Enter VBA code.
4) Ctrl+S to save
5) Close code editor

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
How do I make my Excel calendar pop up? - PART 1 - Excel Tips and Tricks

How do I make my Excel calendar pop up? - PART 2 - Excel Tips and Tricks

How do I make a clickable calendar in Google Sheets? - Excel Tips and Tricks

How do I make my Excel calendar pop up for multiple columns? - Excel Tips and Tricks

How do I make my Excel calendar pop up? - UPDATED - PART1 - Excel Tips and Tricks

How do I make my Excel calendar pop up? - UPDATED - PART2 - Excel Tips and Tricks

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

[VikingSingers]

THIS IS LITERALLY THE ONLY VIDEO I'VE FOUND THAT IS EXACTLY WHAT I WAS LOOKING FOR. THANK

[cucumber]

Thank you so much for your video, Sir.
Can I ask you one thing, Sir?
How would we do if we want to add pop up calendar to only one column or column all the way down below the selected cell?

[marianpalisoc]

Please send me the script. This is what I'm looking for, spent hours scrolling and finding the right video, and here i am finally. Thank you so much. Such a great job.

[morgannaidoo]

I follow your steps the first time and it worked like a bomb. I then had to redo some stuff on the excel and restarted on a new sheet. Refollowed all your steps but the calendar does not disappear when i click out of cells not included on date range. how do i fix that? please thank you

[aminefiama]

Hi!
A huge fan of your work!
Can you please post a video on how to compare values from two tables then return common values in a separate column, in excel?

Thank you!!!

[Hemanthkumar-yqmu]

Hello! Thanks for this video. I followed the step exactly and was able to setup the calendar but it is not disappearing when i click outside of the range. Even the format of the column is not date. Can you please help me here?

[paulspagnuolo]

Beautifull, also How do we make the calendar drop in 2 different areas, like A1:A10 and G1:G10, how do we combine together the 2 areas?

[Lucianst]

Wow, the only video that I have found which easily explains exactly what i needed for my spreadsheet. Thank you so much! Having difficulty however adding to the code to include this date pop up in another part of the spreadsheet that is not directly linked as columns. I have ("A2:B100") which works but when I try to add F2:F100 for some reason it is not accepting this addition to the code? Anyone? Much appreciated for any feedback! Thks

[jaxsterspaku]

This is wonderful. Thanks but how can you do this to different cells that aren’t next to each other?

[saml]

I have three dates for each event (received, started, finished) with them being in different parts of the sheet (Colum F, G, and K). How should I change the range so it only shows in these three columns!

Example: Set rngDate = Range("F2:G100") but I then the calendar won't pop up for K

Thank you so much

[LisaKendrick-xefk]

Great video, but am I missing where you have added the code? I don't see it in the notes.

[AntigaPrinyanilakul]

Thank you very much for your video. It was really helpful to me.

[WilhelmLerch-zd]

thank you very much, it works fine only it does not change the date, it always asks me in an Popup window ok or cancel, I didn't see this happening in your Video Please help.

[clitoriaternatea]

Subscribed, very useful thank u, but where I can get the VBA?

[rikapatra]

Hi Rabi, Very helpful video. But the calendar is freezing if I protect the sheet. I have to protect the sheet so that other objects are not edited, but the calendar is also getting locked. And I am not able to find any option to keep the calendar unlocked. Could you please give a workaround?

[CivilApps]

Thank You, this is exactly what I needed

[kennyho]

Hi thank you for your VBA code. It helps heaps. Can I ask you how can I make the calendar pop up under the cell, not on the bottom right side?

[nmorton]

Brilliant. But it says the script is in the description? I can't see it. Many thanks.

[theekshanahasantha]

very helpful video. But where I can find the script?

[JanetFiederlein]

Thank you, this was extremely helpful!