How do I make my Excel calendar pop up? - Excel Tips and Tricks
HTML-код
- Опубликовано: 29 авг 2024
- 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 Tip and Tricks
• How do I make my Excel...
How do I make my Excel calendar pop up? - PART 2 - Excel Tip and Tricks
• How do I make my Excel...
How do I make a clickable calendar in Google Sheets? - Excel Tips and Tricks
• How do I make a clicka...
#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google
THIS IS LITERALLY THE ONLY VIDEO I'VE FOUND THAT IS EXACTLY WHAT I WAS LOOKING FOR. THANK YOUUUUU!!!
Glad it helped!
This comment actually summarises what I was thinking 😂😂
Please send code
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!!!
Great suggestion!
You video request will be published on coming Tuesday (3 days time)/
Thanks again.
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?
Thank you very much for your video. It was really helpful to me.
Glad it helped
Hey this is what was looking for .
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
I sent this out then figure it out! Thks!
Awesome!
Hey there, what was the fix for this? I’m having the same issue. I need dates in 3 columns, but Range only allows for two selections.
Set rngDate = Range("A2:B100, f2:f100") '**** Modify range ****
Hope this helps@@rosieking7085
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
You're a life saver. Thank you!
Happy to help!
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
Great video, but am I missing where you have added the code? I don't see it in the notes.
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Thankyou!! from Philippines!
Thank you too!
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.
Thank You, this is exactly what I needed
You are welcome!
Thank you, this was extremely helpful!
Glad it helped!
Hi, this is great! However, I can’t find the script even after subscribing. Am I missing something?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
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?
After typing the VBA code, the calendar does not go away or appear in the cells. Can you send me the script? Other thoughts?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
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?
This is wonderful, and I was looking this for long time and please send me the script.
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
EXACTLY WHAT I, LOOKING FOR. COULD YOU PLEASE SEND ME THE VBA CODE. THANK YOU.
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
I followed your instructions, but unfortunately the calendar is always visible. I cannot get it to hide when I am on other cells. And then only pop up when I select the one cell. I only have one cell that needs a calendar
thanks, that's a lot of help
Glad it helped
Hi,
I am getting Compile error:
Expected Function or variable
Kindly, please share your VBA script, and then I'll have a quick look at it.
Thanks I am sharing my script
Hi Rabi, Could you share me the script please, thank you
Hey Rabi Tis is what i'm looking for. How do i get the transcript?
Transcript?
Do you create custom sheets for people?
Yes I do.
@@RabiGurungXyberneticsPlease provide the code files and the links in the description as soon as possible for free 🙏
Subscribed , very useful thank u ,but where I can get the VBA?
I can’t find the code, can you please let me know how to get it?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Can you please share the VBA script?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Спасибо 👍👍👍
can i get the script?? cant find it anywhere in the comment
thanks
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Hello may you send the vb script lines? Thanks in advance
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
hi, can you help me to share the script?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
How can i select two different cells like D2 and J2
Where can I find the VB code link?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Please send me the discription. Thanks
Kindly please join my channel membership.
The VBA code is in the Community post.
Hi Rabi, can you share the VBA script please ?
Please join my channel membership.
The VBA code is in the Community post.
Hello I need the VBA code? How should I do?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Great work...Could you please send script!
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Thanks so much. Can I get the code?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Hi, can you share your calendar code?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Thanks so much for this video.
Please reply with the VB CODE 😢
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Can you please send me the script? Thank you
Please join my channel membership.
The VBA code is in the Community post.
Hey, can you send the script please.
Please join my channel membership.
The VBA code is in the Community post.
Can I have the script, please?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Thanks. May I have the code?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
I need the VBA code
Here is how you can get the VBA script.
Getting VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Plunder Membership"
4) Access all VBA script featured in my channel.
Hi Rabi, thank you! Can you please send me the script?
Hi Rabi, I signed up for the membership and perks to get the script, as directed in the comments below. What I am realizing now is that despite joining, I have to make separate request for the source code and that the paid membership doesn't actually reveal the source code. Am I missing something?
You are right. Our admin is trying to backfill the source code as we speak.
Which Source code are you looking for?
Sorry about that
I have posted the VBA script in the community for you for this video. Please let me know if you need specific VBA code. We are posting all of them as we go though the day.
Have you got all the VBA script you needed.
Please let us know how we can make the process better.
Thanks for being a member.
Hi, can you send me script for calendar? thanks,
Thanks Rabi@@RabiGurungXybernetics
Please send the script! this is great
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Wow! This is very useful. Kindly send me a script please. Thanks a million
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
@@RabiGurungXybernetics Thank you
You are welcome.
Please share with me the script.
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Subscribed🙂❤
Thank you so much, @silverfunnel6819! I really appreciate your support. Your subscription means a lot to me, and I'm thrilled to have you as part of our community. If you have any questions or suggestions, feel free to let me know. Welcome aboard! 😊🎉
Hi, Can I have the code please?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Plunder Membership"
4) Access all VBA script featured in my channel.
can you please send me the code. thank you
Kindly please join my channel membership.
The VBA code is in the Community post.
Were is the script?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Great work...please send script!
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
where is the script?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Can you send me the Script please
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Can u share script
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Plunder Membership"
4) Access all VBA script featured in my channel.
nice .... script pls?
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
hello can i get VBA code
Here is how you can get the VBA script.
Getting VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Plunder Membership"
4) Access all VBA script featured in my channel.
Can you send me the script please?
Please join my channel membership.
The VBA code is in the Community post.
but so slow to pop up
That is new. I ran it in a few different PC and there was no really latency.
Please share the script
Kindly please join my channel membership.
The VBA code is in the Community post.
VBA code?
Here is how you can get all my VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
script pls
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Where is the VBA code ??
Please join my channel membership.
The VBA code is in the Community post.
Please send me the script
hi
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Script Please
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Hey Timi Nepali ho❤
Yes and a bit of no.
EXACTLY WHAT I, LOOKING FOR. APPRECIATE IF YOU COULD SEND ME THE VBA CODE. THANK YOU
Sent
Please send me the script. This is what I'm looking for, spent hours scrolling and finding the right video
Hi Rabi, Could you share me the script please, thank you
Here is how you can get the VBA script.
Getting VBA scripts.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Plunder Membership"
4) Access all VBA script featured in my channel.
Hi Rabi, can you share the VBA script please ?
Please join my channel membership.
The VBA code is in the Community post.
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Hi, please send me the script.thank you
I am not seeing the script in the description can someone share it? thank you
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.
did Rabi send the script?
Can I request for a code? thank you
Dim rngDate As Range, rngSel As Range
Set rngDate = Range("C2:C100 , G2:G100")
Set rngSel = Selection
If Intersect(rngDate, rngSel) Is Nothing Then
Shapes("calendar").Visible = False
Else
Shapes("calendar").Visible = True
Shapes("calendar").Top = ActiveCell.Top + ActiveCell.Height
Shapes("calendar").Left = ActiveCell.Left + ActiveCell.Width
End If
can u send me the VBA code? Tq.
you forgot to leave the script in the description
Dim rngDate As Range, rngSel As Range
Set rngDate = Range("C2:C100 , G2:G100")
Set rngSel = Selection
If Intersect(rngDate, rngSel) Is Nothing Then
Shapes("calendar").Visible = False
Else
Shapes("calendar").Visible = True
Shapes("calendar").Top = ActiveCell.Top + ActiveCell.Height
Shapes("calendar").Left = ActiveCell.Left + ActiveCell.Width
End If
Hey this is just what i was looking for, can I get the script?
VBA Code
Why isn't the script in the description :|
Please send me the Script
Why we can't over write it again
where is the VBA ?
Where is the VBA code?
Very interesting. Can you please share with me the script? I am using MAC
Please send VBA
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
It says Variable uses an Automation type not supported in Visual Basic.
Pls help me.
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?
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
where can i get the script
Here is how you can get the free VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
i need vba code excuse me
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
share me VBA Code
Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Hey Rabi, thank you for your video. Can you please send me the script
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Can you please forward me the script? Thank you.
@bxby_dr1p19 did you get the script from the membership community page?
Here is the link if you have not.
www.youtube.com/@RabiGurungXybernetics/membership
Script?
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.
Please provide the vba code
Thank you for your interest!
From our engineers at Xybernetics, we'd love to see you join our family and become part of our vibrant VBA code-sharing community. Please consider joining us. Below are some directions on how to apply for membership. Here is how you can get the VBA script.
1) Go to my RUclips Channel
ruclips.net/user/RabiGurungXybernetics
2) Click on the Join button
3) Join the "Xyber-nauts" Member
4) Access all VBA script featured in my channel.