Fully Functional Dynamic Calendar Control in VBA (Part-1)
HTML-код
- Опубликовано: 27 апр 2019
- #CalendarControlinVBA #DynamicCalendar #VBAUserform
Hello Friends,
In this video you will learn how to create fully functional dynamic calendar in Excel VBA. We have created this Calendar using VBA User forms and Command buttons. It can used in your VBA Projects.
Fully Functional Dynamic Calendar Control in VBA (Part-2):
• Fully Functional Dynam...
Fully Functional Dynamic Calendar Control in VBA (Part-3):
• Fully Functional Dynam...
Please download this dynamic Calendar control from below given link:
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
I’ve been working with VBA for two years and never knew you could click and drag a user form to copy it to another workbook. Holy cow, this changes everything-thank you! 5:32 (I’m inserting a time stamp because my fat fingers keep closing the video).
Thank you so much this is incredible! You are a true lifesaver! I CANNOT thank you enough!!!!
thank you, i tried many ways, many videos but with your solution, it took only 15 mins. thanks a lot
Sensacional. Ajudou muito. Muito obrigado. (Sensational. It helped a lot. Thank you very much.)
Thanks for your valuable feedback
Fantastic!!! Thanks from Brazil... I was looking for this calendar...
Now you have a follow from Brazil
THANK YOU! This is incredible! I watched it while working out (which is normally boring) but this made the time fly by! Very clear instructions and good speed. I’m so excited to use it!
Glad it helped!
@@PKAnExcelExpert thank you! Is there any way to highlight the current date?
Excellent, best design ever, really simple and powerful.
Thanks for your valuable feedback
Thank you. You are truly an expert.
Thanks for your valuable feedback
Thanks sir,
I have learnt a lot of thing from your video.
Thanks for your valuable feedback
Thank you very much bro, You are Amazing. Very Helpful.
Happy to help
You are brilliant, thank you very much, your lessons helped me a lot! 🌻
Most welcome🙏
absolutely mind blowing.... was searching for this for many days.... truly a gem you are bro...
Please post the videos of VBA userforms more and more..
Sure I will
I forget to thank you for the calender program and the data management system..its really great......
Glad it was helpful!
finally diy datepicker..... thanks so much
Nice, very nice work on both the calendar and video. Good Job! Thank you.
I have followed along the video and have it working, but not sure if I missed something or if it was left out. Which is if I click on a cell that has a date the calendar open to the correct day, but not to the correct month or year. Was the correct month, year left out of your project or did I miss something in the video?
I am using Excel 2019 download. Would you happen to know what versions of Excel this calendar will run on?
Thank you in advance for your response. Enjoy.
Just Wonderful Wow!
Thanks for your valuable feedback
Its really appriciateable....!
Thanks for your valuable feedback
Thanks , interesting!
Thanks for your valuable feedback
@@PKAnExcelExpert We want to watch this video 1 part 2 part and 3 part?
you're amazing really amazing, i was looking for that along time ago, really shapoooooooooooooo
Thanks for your valuable feedback
Execellent tutoral
05:32
Thanks
Thanks for calender
Welcome
Love u brother
Thank you
Thanks
Sir how to change the format of date in textbox
Wow!!!!!! Good job
Thanks for your valuable feedback🙏
can i change commandbutton with label? cz i can't make the commandbutton to flat design, i dont wanna has shadow on my design
Thank you for the very useful and informative posts on RUclips. Can you please tell me where I can alter the VBa code on the calendar to change the week start day to Monday, rather than Sunday as per your code.
You are great sir....thank you very much.
Can I be your student?????
Kindly sir tell me one thing when I take command button there opens codding what to do for alignment of buttons
Nice 😍
Thanks for your valuable feedback
thanks
Welcome
HI , I made calendar form . Thanks . Its a wonderful video . Can you help me to insert this calendar form in another form .
thanks u SIR
you be like Fast and Furious hhh
Hi, I have got Compile error in the year section (With Me.cmbYear) it says Method or data member not found. Could you please help me in that matter?
Sir how to make next & pervious button
Or if you have any video please send video link thanks
Awesome Sir, your tutorial very understandable. Would you tell me please! how to insert Every Date between two date range into my table. I Use MS Access Application. I create a sample form and add there two date text box and a command button. Now I want to insert first date and last date All value. how to write code for this work. I try to create but can not. I am from Bangladesh, I will be very happy if you answer me.
Hello. After using the date picker, I need the dates to show as ranges in 2 different columns. How can I edit the code to do so??
Hello, am failing to use the calendar after installing a 2021 Microsoft Office. It seems the new update does not recognise the date function. Any help?
Love your videos super knowledgeable.. i just have one issue in the sub show_date ..last_date = VBA.DateSerial(Year(first_date), month(first_date) + 1, 1) - 1 ..it points to the Month and gives me a "wrong number of arguments.I have followed your intruction perfectly cant figure out why. Please Help..
i am not able to take value property as when i am running error 380 come up. why is it coming sir??
I added a little calendar icon inside my image box. When I clicked it twice to bring up the Private Sub code, it said Image1_BeforeDragOver(ByVal Cancel as MSForms.ReturnBoolean,......)
It should say Image1_Click(). Why is that happening to me?
Thanks for sharing this video and this calendar, I having problem with this, When i open Calendar, It dos not high lighthe Pc date .
hi dear sir very nice kaya yahi calander access 2013 may is ki vidio mil sakti hy thanks waite for answer
in my project getting this line error"Set btn = Me.Controls("CommandButton" & i)" type mismatch runtime 13 please help Mr PK
Hi Pk sir
I just wanted to know how to access the selectedDate function or method......
Hi i'm from France and i would like to start the week days with monday how can i do thanks, best regards i follow all your videos
Hi, click on userform and find this part:
If VBA.Weekday(first_Date) = i Then
and change it to:
If VBA.Weekday(first_Date, vbMonday) = i Then
Additionally in userform move day names left one place and place Sun right next to Sat
Sir direct bata do kaise calendar download kare
Sir, i can not upload Picture (msg is Invalid Picture)
Hello Sir ,
I can not download your file , Please How to down load ?
Thank Sir
Download link is available in videos description box. Below is the web page link.
www.pk-anexcelexpert.com/fully-functional-dynamic-calendar-control-in-vba/
Can I not change the color of the number buttons?
I need help unable to call calendar
but the coding year not showing in calender
How can I download the second part?
Link has been given in videos description box
i cant get the Calendar.selectedDate function.....is there any other option to get the calender call to a me.txtDate
me too . how about now?
I cannot add picture of arrow
Sir calendar automatically download ho jaye
My year code does not work.
What if I want Monday to be the first day of the week?
We need to modify the code accordingly.
all is good but i cant open it is a error showing
😭
"Can't find project or library" - this error i m facing while creating this.
#qna
Sometimes it works fine but sometimes when i click on the date
The exisying will disappear without any error what to do man 😡😡😡😡😡😡
bro what is password of Calendar Control in VBA file
This is not so good because for one creates calendar you making 2 videos why not complete sir in one video completely confusing video
Kindly help me regarding this I have completed video 1 process and couldn't retrieve the file coz after completing that video I stopped it and continue now but couldn't able to extract