Sir thanks for your help to many of us looking for a calendar function. Thanks for allowing the viewers to download the file. One doubt sir - how to use this in a userform - VBA? regards sir
Sir, I thank you from the bottom of my heart for tutorials. They help me a lot. Actually, I am a management student and want to learn simple coding. Sir can u upload some videos regarding basic coding.
Thanks for your feedback! Would request you to check our playlist. Have already uploaded tutorials. Please post your comment on any video, if you need any clarification. Thanks!
Hi, great work! i only have one problem, i wanted to change the previous year to 65 years back. it wont, it sets only to up to 50 years back. may i know how to set it? thank you
Thanks a Lot; I Highly Appreciate Your Hard Work...... I Have a Query How to use the Given calendar to input a date in a "Active Cell" Other than - "Text Box , Command Button and Label"......... Cause Have to Copy and paste Date with other Data thru Macro and is only copying data from Active Cell ...........Kindly Help
Hi, thanks a lot for this cool custom calendar, so I can use this as alternative date picker in my 64bit excel. I have tried to call the custom calendar from a command button and it works well. Now I want to replace the command button with a calendar icon, but I have no idea how to do it. Can you please advise how to add a "calendar icon" to my user form? so then I can call the custom calendar from it.
Hello Brother, It's a really very very helpful tutorial. Can you show me how to use this source code exactly in any kind of form. I can't install this. Hoping your great help.
Thank you Sir for this excellent video tutorial, but I encounter the date did not appear in my dropbox. can you help me how to see the selected date in my dropbox... thanks
hi guys, i've downloaded your datepicker and it works great, accept for one thing. The first day of every month is sunday. So if month ends on wednesday, still next month says 1th is on sunday. Didn't touch the code. Whats the deal here? Tried email but didn't get an answer to my problem. Help me out please!!
When calling this from a userform with the showmodal property set to false, it returns nothing to the text box. It actually wipes out whatever value may have been there. Anyone have any ideas?
In that case, code and text available on button should be adjusted accordingly. There wouldn't be any difference in usage. Please use the same calendar as it will take time to amend.
Il programma non funzionava bene: i giorni della settimana (lun,mar,) non erano allineati con il numero dei giorni ( 1,2,..31). Ho scoperto, facendolo girare che nella sub "Private Sub AssignDay(month As Integer, year As Integer)" la variabile sDay era uguale a "mar" ( in inglese Tue"). Ho sostituito tutti i giorni della settimana da inglese a italiano in quste linee " Me.D2.Caption = IIf(Me.D1.Caption "", Val(Me.D1.Caption) + 1, IIf(sDay = "mar", "1", "")) , e tutto funziona alla meraviglia. Grazie moltissimo per aver condiviso questo bellissimo tool, che rende più professionale i nostri piccoli lavori. Un saluto dall' Italia.
Hey TheDataLabs, this application would work great for a couple applications I have for Microsoft Project. I downloaded the file via the link you provided. However, the source code is locked. Do you have a version that is unprotected that you would be willing to share? Thanks in advance!!
Hi. The problem is caused by attempting to supply a value that does not appear in the dropdown list. For example, running this in 2021(or later) will produce the error because the procedure that builds the combobox list starts from (2021 - 1) and ends 50 years from current date. The textbook contains a year of 2019 hence the process attempts to provide 2019 which is not in the list. The solution is to amend the code in routine Add_Year to set iPreviousYear to (for example 2) so that the list of years starts from 2 years previous and therefore includes 2019. This example in its current form has not worked properly since 1st Jan 2021. Suggest the following code changes for previous 2 years, current year and next 2 years (2019 to 2023 for current year 2021): Procedure to add years to calendar Private Sub Add_Year() Dim i As Integer Dim iPreviousYear As Integer Dim iCurrentYear As Integer Dim iLastYear As Integer iPreviousYear = 2 ' Please assign 1 with other numbers if you want to add more than 1 previous years iLastYear = 2 ' You can reduce or increase the last year. Pleas assign the last year value iCurrentYear = Val(Format(Date, "YYYY")) Me.cmbYear.Clear For i = (iCurrentYear - iPreviousYear) To (iCurrentYear + iLastYear) Me.cmbYear.AddItem i Next i End Sub
This calendar is not working properly when enter the value of day less than or equal to 12. It's works properly when value of day is greater than 12 or equal to the end of month.
I have same problem. How can I change this setting. I am from Turkey. And also I will share this program with my friend. is it going to be a problem for her.
@@thedatalabs Sir, I want a time calendar so that I can only mentions the time in it, if there is any such application, then please give me the mail . My Mail ID : balbeer.singh452@gmail.com
Sir Sheet "Database" se another sheet "Showing Report" me vba code ke jariye date and gender se find kare and with photos bhi aa jaye fpath location se Plz help Kare
I appreciate you letting me download your file, sir. You are an honest individual. My day is complete because of you!
Thanks for your appreciation!
This is really an awesome add-in tool which does not come in-house with Excel. Thanks TheDataLabs for bringing this on table.
Thanks for your appreciation!
Thank you, dear The best channel on UA-cam
very smart Calendar ... look vise! and also design! ........ update my knowledge after see this video ......... thanks a lot of bro......
Thank you for sharing the code with us all, thank you. It help me a lot.
Watching this video. I have learned much more.
Very helpful. Thanks for sharing!
Sir, thank you for your permission to download the file. Thank you
Very helpful sir... Thanx so much.. So you have video tutorial to add time or clock? Thanx
hi! this is a great video and contribution. thank you very much!
tutorial plz step by step . you are awesome man.
Sir thanks for your help to many of us looking for a calendar function. Thanks for allowing the viewers to download the file. One doubt sir - how to use this in a userform - VBA? regards sir
Really awesome bro...Thanks a lot
thank you
Sir, I thank you from the bottom of my heart for tutorials. They help me a lot. Actually, I am a management student and want to learn simple coding. Sir can u upload some videos regarding basic coding.
Thanks for your feedback! Would request you to check our playlist. Have already uploaded tutorials. Please post your comment on any video, if you need any clarification. Thanks!
good job sir
Thanks for your appreciation!
Hi, great work! i only have one problem, i wanted to change the previous year to 65 years back. it wont, it sets only to up to 50 years back. may i know how to set it? thank you
Big like man. I have 64 system in my computer which does not support adding date picker tool.
Thanks a Lot; I Highly Appreciate Your Hard Work...... I Have a Query How to use the Given calendar to input a date in a "Active Cell" Other than - "Text Box , Command Button and Label"......... Cause Have to Copy and paste Date with other Data thru Macro and is only copying data from Active Cell ...........Kindly Help
Bro ... this is awesome
Thank you so much for sharing 🙏 How can I make monday first day of the week?
Hi, thanks a lot for this cool custom calendar, so I can use this as alternative date picker in my 64bit excel. I have tried to call the custom calendar from a command button and it works well. Now I want to replace the command button with a calendar icon, but I have no idea how to do it. Can you please advise how to add a "calendar icon" to my user form? so then I can call the custom calendar from it.
Hello Brother,
It's a really very very helpful tutorial. Can you show me how to use this source code exactly in any kind of form. I can't install this. Hoping your great help.
Thank you Sir for this excellent video tutorial, but I encounter the date did not appear in my dropbox. can you help me how to see the selected date in my dropbox... thanks
Is it possible to fill in those blanks for the days of the previous month and the next month? Sorry my english, thanks
hi guys, i've downloaded your datepicker and it works great, accept for one thing. The first day of every month is sunday. So if month ends on wednesday, still next month says 1th is on sunday. Didn't touch the code. Whats the deal here?
Tried email but didn't get an answer to my problem. Help me out please!!
i'm using Office 2019 by the way
I want to make my own calendar, please make a tutorial video 🙏🙏
Hi, Very nice video. I have one problem , I can not find the (txtDay) in the Design. Please help! Thanks!
Thanks for your appreciation! Please share this file. I will go through that and fix it for you. Thanks!
@@thedatalabs Thank You!
sir i am also trying to make one leave tracker. is it okay if i make some improvements and will give you idea if i make some necessary changes??
Sure, please develop the tracker and let me know if any assistance required.
When calling this from a userform with the showmodal property set to false, it returns nothing to the text box. It actually wipes out whatever value may have been there. Anyone have any ideas?
HOW TO GO TO A TEXBOX IN A FORM BY CLICKING ON A DATE?
PLEASE HELP! I have a problem with this calendar. The first of every month are always on a sunday? why do i have this defect?
What if monday is first day of week? Nice tutorial, thank you 👍
In that case, code and text available on button should be adjusted accordingly. There wouldn't be any difference in usage. Please use the same calendar as it will take time to amend.
But what code should be adjusted?
Hi ...
When I add the edit button I can't edit the date form this calendar Can you solve my problem
Il programma non funzionava bene: i giorni della settimana (lun,mar,) non erano allineati con il numero dei giorni ( 1,2,..31). Ho scoperto, facendolo girare che nella sub "Private Sub AssignDay(month As Integer, year As Integer)" la variabile sDay era uguale a "mar" ( in inglese Tue"). Ho sostituito tutti i giorni della settimana da inglese a italiano in quste linee " Me.D2.Caption = IIf(Me.D1.Caption "", Val(Me.D1.Caption) + 1, IIf(sDay = "mar", "1", "")) , e tutto funziona alla meraviglia. Grazie moltissimo per aver condiviso questo bellissimo tool, che rende più professionale i nostri piccoli lavori. Un saluto dall' Italia.
how to disable the previous date on this custom calender??
SIR JI CALENDAR WITH CLOCK TIME BHI ADD KARVA DETE OR SUNDAY RED COLOUR HIGHLIGHT HO
Good suggestion. I will try to add these features. Thanks!
Sir how do I add previous years more than 50 it gave error when I put value greater than 50 please help
i just downloaded, and its telling me " could not run value property, invalid value property
I need more information.. How do I contact you??
Hey TheDataLabs, this application would work great for a couple applications I have for Microsoft Project. I downloaded the file via the link you provided. However, the source code is locked. Do you have a version that is unprotected that you would be willing to share? Thanks in advance!!
Thanks for your appreciation! Will share the unprotected version.
Thank you very much :-)
Hi Stephen, I have provided VBA password in description box. Thanks!
Thanks again @@thedatalabs!!
Is there a way to get the unsecured version since the uploaded version locked? Thanks.
I have uploaded unprotected version. Will check and upload the same, if there is any protection.
Hi, I have provided the VBA code in description box. Please check. Thanks!
Hello Sir, Can you please send me a link for VBA Source Code for Calendar.
Please download the entire VBA code and file from the link provided in description box. You can find the VBA password as well. Thanks!
@@thedatalabs Hi my friend, abcd@121 is password, isn't it? It seems to be wrong. I can not open VBA project by this password
Method 1 download button gives error ‘Invalid Property value’. Can you pl provide the solution to it.
Hi. The problem is caused by attempting to supply a value that does not appear in the dropdown list. For example, running this in 2021(or later) will produce the error because the procedure that builds the combobox list starts from (2021 - 1) and ends 50 years from current date. The textbook contains a year of 2019 hence the process attempts to provide 2019 which is not in the list. The solution is to amend the code in routine Add_Year to set iPreviousYear to (for example 2) so that the list of years starts from 2 years previous and therefore includes 2019. This example in its current form has not worked properly since 1st Jan 2021.
Suggest the following code changes for previous 2 years, current year and next 2 years (2019 to 2023 for current year 2021):
Procedure to add years to calendar
Private Sub Add_Year()
Dim i As Integer
Dim iPreviousYear As Integer
Dim iCurrentYear As Integer
Dim iLastYear As Integer
iPreviousYear = 2 ' Please assign 1 with other numbers if you want to add more than 1 previous years
iLastYear = 2 ' You can reduce or increase the last year. Pleas assign the last year value
iCurrentYear = Val(Format(Date, "YYYY"))
Me.cmbYear.Clear
For i = (iCurrentYear - iPreviousYear) To (iCurrentYear + iLastYear)
Me.cmbYear.AddItem i
Next i
End Sub
Calling the date picker from an input form?
Please watch this tutorial where we have used custom calendar in user form. ua-cam.com/video/i1DjR9ZPcRc/v-deo.html
Also how calculate my age in excel VBA coding only two textbox one contains date of birth other calculatrd age please very soooooon
SIR JI
HUM AAPKA CALENDAR KO MIDIFY KAR SAKTE HAI ??
Yes please. You can make the changes and share with others as well. There is no restriction. Moreover, I have developed this for my viewers. Thanks!
THANKS FOR PERMISION PLEASE SEND ME YOUR CONTACT TAKI ME CHANGE KIYA HUA AAPKO BHEJ SAKU
You can find our email id in description box. Thanks!
This calendar is not working properly when enter the value of day less than or equal to 12. It's works properly when value of day is greater than 12 or equal to the end of month.
It seems date is set to different format in regional settings. Please make it the changes accordingly. Thanks!
I have same problem. How can I change this setting. I am from Turkey. And also I will share this program with my friend. is it going to be a problem for her.
@@thedatalabs Could you check my question
The method 1 text box and method 1 commandbutton isn't working
See solution above
This is not working for Excel 365, portuguese language :(
See solution above
Sir
Plz support file hrs example 1245 in vba coding of text box
I didn't get your question. Could you please explain the issue little bit more? Thanks!
@@thedatalabs Sir, I want a time calendar so that I can only mentions the time in it, if there is any such application, then please give me the mail .
My Mail ID : balbeer.singh452@gmail.com
Sir Sheet "Database" se another sheet "Showing Report" me vba code ke jariye date and gender se find kare and with photos bhi aa jaye fpath location se
Plz help Kare
Sir ji this calendar contains year upto only 2020 plese increase yearmore than2030
xin pass được không bạn
You can download it. I have provided the link in description box.
122
Thank you