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

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

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

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

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?

Thank you. You are truly an expert.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Excellent, best design ever, really simple and powerful.

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback

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

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

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

@PKAnExcelExpert

5 жыл бұрын

Thanks for your valuable feedback

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

@PKAnExcelExpert

3 жыл бұрын

Happy to help

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

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

@PKAnExcelExpert

3 жыл бұрын

Glad it was helpful!

Just Wonderful Wow!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

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

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback

Its really appriciateable....!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

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.

finally diy datepicker..... thanks so much

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?

Thanks for calender

@PKAnExcelExpert

4 жыл бұрын

Welcome

Execellent tutoral 05:32

@PKAnExcelExpert

Жыл бұрын

Thanks

Love u brother Thank you

@PKAnExcelExpert

3 жыл бұрын

Thanks

@indiavikas-computer

3 жыл бұрын

Sir how to change the format of date in textbox

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

Wow!!!!!! Good job

@PKAnExcelExpert

2 жыл бұрын

Thanks for your valuable feedback🙏

Nice 😍

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

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

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

thanks

@PKAnExcelExpert

2 жыл бұрын

Welcome

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

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

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

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

Sir direct bata do kaise calendar download kare

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.

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

thanks u SIR you be like Fast and Furious hhh

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?

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?

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?

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

Hi Pk sir

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

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

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

Can I not change the color of the number buttons?

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

but the coding year not showing in calender

Sir calendar automatically download ho jaye

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

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/

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

I need help unable to call calendar

How can I download the second part?

@PKAnExcelExpert

3 жыл бұрын

Link has been given in videos description box

My year code does not work.

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

@PKAnExcelExpert

2 жыл бұрын

We need to modify the code accordingly.

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

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

@dharom1

Жыл бұрын

😭

I cannot add picture of arrow

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？

#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