Fully Functional Dynamic Calendar Control in VBA (Part-1)

Подписаться 275 тыс.

Просмотров 107 тыс.

50% 1

#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-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
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-m...

Опубликовано:

11 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 93

@TheRealMake-Make 3 года назад

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).

@eleonoraa.c.1706 Год назад

You are brilliant, thank you very much, your lessons helped me a lot! 🌻

@PKAnExcelExpert Год назад

Most welcome🙏

@edmuva 2 года назад

Excellent, best design ever, really simple and powerful.

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@michelenarvaez9271 Год назад

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!

@PKAnExcelExpert Год назад

Glad it helped!

@michelenarvaez9271 Год назад

@@PKAnExcelExpert thank you! Is there any way to highlight the current date?

@manohartimothy5825 3 года назад

I forget to thank you for the calender program and the data management system..its really great......

@PKAnExcelExpert 3 года назад

Glad it was helpful!

@gokcentunal8672 4 года назад

thank you, i tried many ways, many videos but with your solution, it took only 15 mins. thanks a lot

@FernandoRamosOstroswky 3 года назад

Fantastic!!! Thanks from Brazil... I was looking for this calendar... Now you have a follow from Brazil

@davecks3042 4 года назад

Thank you. You are truly an expert.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@carolineodonnell8458 3 года назад

Thank you so much this is incredible! You are a true lifesaver! I CANNOT thank you enough!!!!

@norulzanamohamedsamuri1364 3 года назад

finally diy datepicker..... thanks so much

@manishkumarsah5417 5 лет назад

Thanks sir, I have learnt a lot of thing from your video.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@wasymelomda897 2 года назад

you're amazing really amazing, i was looking for that along time ago, really shapoooooooooooooo

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@santhoshkumar-in3qc 4 года назад

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..

@PKAnExcelExpert 4 года назад

Sure I will

@rajamanickamramalingam8786 Год назад

Execellent tutoral 05:32

@PKAnExcelExpert Год назад

Thanks

@elghaly2020 4 года назад

Thank you very much bro, You are Amazing. Very Helpful.

@PKAnExcelExpert 4 года назад

Happy to help

@luizhenriquedacostajardim5511 3 года назад

Sensacional. Ajudou muito. Muito obrigado. (Sensational. It helped a lot. Thank you very much.)

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@indiavikas-computer 4 года назад

Love u brother Thank you

@PKAnExcelExpert 4 года назад

Thanks

@indiavikas-computer 4 года назад

Sir how to change the format of date in textbox

@carlo9567 2 года назад

Wow!!!!!! Good job

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@gausselim1474 4 месяца назад

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?

@prashantmeher6260 4 года назад

Thanks for calender

@PKAnExcelExpert 4 года назад

Welcome

@awnikarkazan7488 3 года назад

Just Wonderful Wow!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@poeticnight9339 4 года назад

Its really appriciateable....!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@dalitsotembo603 2 года назад

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?

@robs4911 4 месяца назад

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..

@bezualemfisseha2119 3 года назад

thanks

@PKAnExcelExpert 3 года назад

Welcome

@abmujahid 3 года назад

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?

@djbcybertench Год назад

Thank you for the very useful and informative posts on RU-vid. 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.

@afghaninadjib4628 4 года назад

can i change commandbutton with label? cz i can't make the commandbutton to flat design, i dont wanna has shadow on my design

@nora1784 2 года назад

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??

@rsiddique1584 Год назад

Sir direct bata do kaise calendar download kare

@rc7184 4 года назад

i am not able to take value property as when i am running error 380 come up. why is it coming sir??

@umefarwa1899 4 года назад

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

@KGNPATAL 3 года назад

in my project getting this line error"Set btn = Me.Controls("CommandButton" & i)" type mismatch runtime 13 please help Mr PK

@BestFriendsForeverTrue 3 года назад

Nice 😍

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@ferozmahmud5552 3 года назад

You are great sir....thank you very much. Can I be your student?????

@umefarwa1899 4 года назад

Kindly sir tell me one thing when I take command button there opens codding what to do for alignment of buttons

@hamdanfaisal9503 2 года назад

Sir, i can not upload Picture (msg is Invalid Picture)

@niveditarajput896 Год назад

Can I not change the color of the number buttons?

@Fazwaans 2 года назад

Thanks for sharing this video and this calendar, I having problem with this, When i open Calendar, It dos not high lighthe Pc date .

@yogesyoges2143 Год назад

but the coding year not showing in calender

@CarrierRates 2 года назад

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.

@SantoshSharma-ty6bh 2 года назад

"Can't find project or library" - this error i m facing while creating this.

@manishsharma-go2fi 2 месяца назад

I cannot add picture of arrow

@dharom1 Год назад

all is good but i cant open it is a error showing

@dharom1 Год назад

😭

@Sebastien_Frederic 4 года назад

Thanks , interesting!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@sujeetvichare5825 4 года назад

@@PKAnExcelExpert We want to watch this video 1 part 2 part and 3 part?

@aimare19 4 года назад

thanks u SIR you be like Fast and Furious hhh

@bprabhuace 3 года назад

HI , I made calendar form . Thanks . Its a wonderful video . Can you help me to insert this calendar form in another form .

@mastg99 4 года назад

Sir how to make next & pervious button Or if you have any video please send video link thanks

@manohartimothy5825 3 года назад

I just wanted to know how to access the selectedDate function or method......

@SAJONY-gk7fd 3 года назад

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.

@Swamhtetyan 5 лет назад

Hello Sir , I can not download your file , Please How to down load ? Thank Sir

@PKAnExcelExpert 5 лет назад

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/

@rsiddique1584 Год назад

Sir calendar automatically download ho jaye

@manohartimothy5825 3 года назад

i cant get the Calendar.selectedDate function.....is there any other option to get the calender call to a me.txtDate

@chunlanwei8922 Год назад

me too . how about now？

@9035451964bose 3 года назад

I need help unable to call calendar

@malikstudio7331 3 года назад

hi dear sir very nice kaya yahi calander access 2013 may is ki vidio mil sakti hy thanks waite for answer

@9035451964bose 3 года назад

Hi Pk sir

@carlo9567 2 года назад

What if I want Monday to be the first day of the week?

@PKAnExcelExpert 2 года назад

We need to modify the code accordingly.

@charlesthamba4514 3 года назад

How can I download the second part?

@PKAnExcelExpert 3 года назад

Link has been given in videos description box

@rayhanulislam4104 4 года назад

My year code does not work.

@TheLaopi 4 года назад

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

@M4R3K0001 4 года назад

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

@indiavikas-computer 4 года назад

#qna Sometimes it works fine but sometimes when i click on the date The exisying will disappear without any error what to do man 😡😡😡😡😡😡