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 https://youtube.com/shorts/n4bya-Jds_g?feature=share
How do I make my Excel calendar pop up? - PART 2 - Excel Tips and Tricks https://youtube.com/shorts/239ITbMUbhw?feature=share
How do I make a clickable calendar in Google Sheets? - Excel Tips and Tricks https://youtube.com/shorts/mCog_mBsxRo?feature=share
How do I make my Excel calendar pop up for multiple columns? - Excel Tips and Tricks https://youtube.com/shorts/Nco59X0FSow?si=B-THBk69Y-BmiK_l
How do I make my Excel calendar pop up? - UPDATED - PART1 - Excel Tips and Tricks https://youtube.com/shorts/r_KvJq4Dp34?si=Scc4BvnbqQjMCNZy
How do I make my Excel calendar pop up? - UPDATED - PART2 - Excel Tips and Tricks https://youtube.com/shorts/mDG2y5Uddi8?si=ufxUVFsZh9tHPBzn
Popup Calendar in Excel - Excel Tips and Tricks https://youtube.com/shorts/hnNQhgDBR_w?si=d8GrpEfdfwg_2S5X
How do I make my Excel calendar pop up in any cell? - Excel Tips and Tricks https://youtube.com/shorts/2pL3XrW_jCo?si=hkWqNe7r8kEjZhUH
How do I make my Excel calendar pop up?,How do I create a date picker in VBA?,How do I create a date picker in Excel?,How do I make a date picker in Excel VBA?,How do I open a date picker in VBA?,
00:00There's recently been a lot of questions about how you can add a pop-up calendar on Excel spreadsheet, similar to what Google has done it this way.
00:09So here I'm going to demonstrate to you how you can actually set those up in your typical good old Excel here.
00:15So the first thing you have to do is to go to Developer tab and go to Add-in.
00:19If your Developer tab is not here, right-click anywhere on the ribbon, customize the ribbon, and you'll come up with this.
00:25In here, make sure that the Developer is checked on like this, and click OK, and the Developer tab should be available.
00:32Once you have the Developer tab, go to Add-in.
00:35In here, you're going to click on either Store or Office Store like this, and then on the search bar, you're going to type Date like this, and hit Enter.
00:44Once that's done, a mini calendar and a date picker will come up here.
00:48Click on Add, and then click on Continue.
00:50And this, what it does is that it will add you the little miniature calendar here.
00:56I'm just going to resize it, and over here, I'm going to press this X to hide this configuration menu here, just like this, and you'll look something like that.
01:05And if you want to reposition your mini pop-up calendar, just click on the black line, not on this line here, anywhere here, but click on this black line, and just move it anywhere you want.
01:16It doesn't matter.
01:17Right now, you can leave it anywhere you want.
01:19And then after that, once that's done, we're going to have to name this object or the shape.
01:24Go to Home, and then go under Editing, go to Find and Select, and click on the Selection panel here like this.
01:34And right now, the name for this object is Add-in 1.
01:38We're just going to change it to maybe call it Calendar, like that, and hit Enter.
01:43Once that's done, we're just going to close this guy here, and then next thing we're going to have to do is to add a VBA script.
01:50Right-click on your worksheet here, and then click on View Code.
01:56This should open up a VBA editor here, and one thing you're going to do is you're going to make sure that you are on the right sheet.
02:03My sheet number is 199, and this 199 here.
02:07And after that, go to Pulldown, Worksheet, and this particular subroutine should appear.
02:13In here, you're going to enter the following script.
02:16I'll leave the script in the description, but if you want a quick response or if you want me to send you a script,
02:22please write in a comment, and I'll send you the script on the comment itself.
02:27One thing to note over here is that this D2 and E18 is the range for my calendar here.
02:35So if I click anywhere here from D2 all the way to E18, the calendar will pop up.
02:42But if I click anywhere outside, the calendar pop up will be ignored.
02:46I'll show you what I mean by that shortly.
02:48Another thing that you want to change, you want to customize it, is that I did call my calendar object Calendar itself.
02:55If you change this to maybe call it date-time calendar, you're going to have to change this text, this text, this text, and this text.
03:03So those two are the settings that you're going to have to do.
03:05This one in particular, this is what you must change.
03:09Let me show you D2 and E18 here.
03:12So next thing you're going to have to do is press Ctrl-S to save it, and let's close the VBA editor like this.
03:18Now if you click anywhere on your worksheet, your mini calendar will disappear.
03:23But if you click anywhere from D2 to E18, the mini calendar will appear.
03:29Let me show you.
03:29Click on it.
03:30You see the mini calendar appear.
03:31Select the date, and the date gets populated here.
03:34And then let's say click another one over here.
Be the first to comment