mere abhivaadan, bhaee. It's only been a few weeks since I've been watching videos about programming with Excel VBA. I think it's crazy to try to carry out a project without having the basic knowledge that is required. The detailed manner of your explanations has caught my attention. With you it has been the only one (with the elementary knowledge I have on the subject) that I have been able to follow almost to the end the highly pedagogical instructions that you offer in your video "Calendar Design in Excel VBA. Having said the above, I managed to create the sheets in an excel book and make a form to enter the data in the Database sheet. In this form I included a TextBox to put the date of the transaction. When I found your video on how to create a calendar from scratch I decided to add to that TextBox a CommandButton that calls the Calendar that you patiently teach and to be able to select the date. I have followed your instructions step by step paying all my attention but even so (almost at the end) I cannot get it to work and for this reason I have decided to write to you trying to know if you on your channel have the codes that are needed, so is it posible, download them and be able to review all one by one, step by step. First of all, I apologize for occupying your attention on my request but I will be very grateful if you can help me. Thank you very much. Sincerely. Nelson R.
Amazing, you are great, thank you so much, you explain each code very clearly... finally I can make my own datepicker after looking in every tutorial vba.
Thank you so much for this tutorial about creating a calender. This is one of the best I have ever seen. And I have seen a lot. A step by step approach what I like a lot because that is also my style when I'm teaching (yes, I'm teaching Excel besides my regular job :)). Take the time to watch this tutorial (it can take you a few hours but it's worth every minute of your time!!). And than you can also modify the calendar based on your needs.
A very great job! I build it completely according the video and it all works. A Very good guide. Is there a chance to modify so it would be possible to select a period of days, for example to select a week vacation? I wonder and would love to here it. Thanks for all the great work.
This is truly the best video I've found regarding a date picker for Excel 64 Bit! Any idea how I can make the text larger for the combo boxes? They seem a bit small.
Thanks for your good work, the problem I am facing is that, highlighting a pick date only happen on the current month and year but any other date, will not appear. Any help on that? Ones again thank you so much and keep it up.
Thank you for very nice calendar. I needed for mm/dd/yyyy format. so, I did it like Me.TextBox1.value = Format(VBA.Left(Me.ComboBox1.value, 3) & "/" & btn.Caption & "/" & Me.ComboBox2.value, "m") & "/" & btn.Caption & "/" & Me.ComboBox2.value btn.BackColor = VBA.RGB(255, 255, 255). I was wondering if it can be done other way? Also, wondering if you have programed for mouseover color and today's default date?
I have trouble in the end of the video about using the DatePicker in Userform1. When I use - Call Calendar.DatePicker(Me.CommandButton1) - It did not work. The message was Run Time Error 13. Do you know what it means? The Date Picker was able to open, but once I selected the date, it became error. The date selected will not go to CommandButton1. Pls advise. Thank you for reply.
Hi, if the calendar userform is shown as vbmodeless so it can remain displayed while a user selects a worksheet cell or range of cells, when command buttons 1 - 42 are selected, where would the code go to populate the date from Textbox1 into the active cells?
Sorted Option Explicit Sub ButtonClick(btn As MSForms.CommandButton) If btn.Caption "" Then Me.TextBox1.Value = btn.Caption & "-" & VBA.Left(Me.ComboBox1.Value, 3) & "-" & Me.ComboBox2.Value Dim c As Excel.Range For Each c In Selection c.Value = (Format(Me.TextBox1.Value, "m-d-yyyy")) Next c End If End Sub
Good afternonn, I am making your vba calendar. Everything works until the step where I click on a date and my date is supposed to appear in my textbox1 box at 42 minutes and 30 seconds. I don't have any dates written in this box. I am discouraged. For what. Thank you for your help. Audrey
Hello sir, I recreated your calendar, unfortunately I have a small problem in my country the week starts on Mondays and I can't figure out how or where I have to change the code so that the week starts on a Monday. Could you please help me?
Thanks for a really nice calendar. Great job of you. Used a lot :-) It would have been cool if you could have inserted a week number in it as well. Hope this comes. Sorry for my bad English
man i love you!!! i dont know anything about VBA but after all of your explanation i luckly did it on my first report. thank you so much!
Hello from 🇮🇳
As always this video was very helpful.
You are doing a really great job.
mere abhivaadan, bhaee.
It's only been a few weeks since I've been watching videos about programming with Excel VBA.
I think it's crazy to try to carry out a project without having the basic knowledge that is required.
The detailed manner of your explanations has caught my attention. With you it has been the only one (with the elementary knowledge I have on the subject) that I have been able to follow almost to the end the highly pedagogical instructions that you offer in your video "Calendar Design in Excel VBA. Having said the above, I managed to create the sheets in an excel book and make a form to enter the data in the Database sheet. In this form I included a TextBox to put the date of the transaction. When I found your video on how to create a calendar from scratch I decided to add to that TextBox a CommandButton that calls the Calendar that you patiently teach and to be able to select the date.
I have followed your instructions step by step paying all my attention but even so (almost at the end) I cannot get it to work and for this reason I have decided to write to you trying to know if you on your channel have the codes that are needed, so is it posible, download them and be able to review all one by one, step by step.
First of all, I apologize for occupying your attention on my request but I will be very grateful if you can help me.
Thank you very much.
Sincerely.
Nelson R.
Greate - I've been trying to do this for some time. Now I've got one. Thankyou!!
Amazing, you are great, thank you so much, you explain each code very clearly... finally I can make my own datepicker after looking in every tutorial vba.
Thank you After many time find somthing good ,sorry for my english
Thank you so much for this tutorial about creating a calender. This is one of the best I have ever seen. And I have seen a lot. A step by step approach what I like a lot because that is also my style when I'm teaching (yes, I'm teaching Excel besides my regular job :)). Take the time to watch this tutorial (it can take you a few hours but it's worth every minute of your time!!). And than you can also modify the calendar based on your needs.
Really good explanation and great idea, Thanks Man
what a great instructor, really helpful, Thanks a lot
That was great man.
Thank you
Thank you a lot. You did a great job!
Very Excellent training Sir
A very great job! I build it completely according the video and it all works. A Very good guide. Is there a chance to modify so it would be possible to select a period of days, for example to select a week vacation? I wonder and would love to here it. Thanks for all the great work.
Excelente aporte. Muchas gracias.
This is truly the best video I've found regarding a date picker for Excel 64 Bit! Any idea how I can make the text larger for the combo boxes? They seem a bit small.
How to set color for sunday and saturday
Great Video. It solves my issue.
Please advise how to highlight into white for the chosen date from textbox?
Thanks in advance.
Great tutorial Sir. How can I make monday first day of the week?
Thanks for your good work, the problem I am facing is that, highlighting a pick date only happen on the current month and year but any other date, will not appear. Any help on that? Ones again thank you so much and keep it up.
Great man thank u!!!
Thank you for very nice calendar. I needed for mm/dd/yyyy format. so, I did it like Me.TextBox1.value = Format(VBA.Left(Me.ComboBox1.value, 3) & "/" & btn.Caption & "/" & Me.ComboBox2.value, "m") & "/" & btn.Caption & "/" & Me.ComboBox2.value
btn.BackColor = VBA.RGB(255, 255, 255). I was wondering if it can be done other way? Also, wondering if you have programed for mouseover color and today's default date?
Thank you so much for this calender vba, how show public holiday userform ?
How to make the current date highlighted instead of highlighting selected date?
Overall the vdo is very helpful. Thank you
Great video! How can you change the size of the text in the combo boxes?
You should zoom screen when you write code
I have trouble in the end of the video about using the DatePicker in Userform1. When I use - Call Calendar.DatePicker(Me.CommandButton1) - It did not work. The message was Run Time Error 13. Do you know what it means? The Date Picker was able to open, but once I selected the date, it became error. The date selected will not go to CommandButton1. Pls advise. Thank you for reply.
Hi, if the calendar userform is shown as vbmodeless so it can remain displayed while a user selects a worksheet cell or range of cells, when command buttons 1 - 42 are selected, where would the code go to populate the date from Textbox1 into the active cells?
Sorted
Option Explicit
Sub ButtonClick(btn As MSForms.CommandButton)
If btn.Caption "" Then
Me.TextBox1.Value = btn.Caption & "-" & VBA.Left(Me.ComboBox1.Value, 3) & "-" & Me.ComboBox2.Value
Dim c As Excel.Range
For Each c In Selection
c.Value = (Format(Me.TextBox1.Value, "m-d-yyyy"))
Next c
End If
End Sub
I am getting run time error 380. Could not see list index property. Invalid property value. Under private sub command button 43. Can you help
Good afternonn,
I am making your vba calendar. Everything works until the step where I click on a date and my date is supposed to appear in my textbox1 box at 42 minutes and 30 seconds. I don't have any dates written in this box. I am discouraged. For what. Thank you for your help. Audrey
Hello sir, I recreated your calendar, unfortunately I have a small problem in my country the week starts on Mondays and I can't figure out how or where I have to change the code so that the week starts on a Monday. Could you please help me?
this is a great video...but after 8 hours practice I could not pup all the dates ...just got 1 to 4 ....where i am making mistake
Thanks for a really nice calendar. Great job of you. Used a lot :-)
It would have been cool if you could have inserted a week number in it as well. Hope this comes.
Sorry for my bad English
I have solved this :-)
How to change the date format from 10-Feb-21 to 10.02.2021 ???
Super nice 👍 Thank you 👌 How to make monday first day of week?
'====================
For i = 1 To 7 'Set first date of month
Set btn = Me.Controls("CommandButton" & i)
If VBA.Weekday(first_Date, vbMonday) = i Then 'Her endres ukestart dag, sett inn: ,vbMonday
btn.Caption = "1"
Else
btn.Caption = ""
End If
Next i
@@rolfarneberg9182 Tusen takk!!!
Namastay Dai! I completed your calendar project but I don't know how to fix calendar template accordingly its command button in userform. Help me!
Amazing, is it available for download? Thx
How can I use your Date Picker in a fixed cell?
Thank you very much
highlight date is not working if you select different month and year.
Sir your video is great but pracice file is protected .how can we practice?
I am facing run time error 380. Could not see the Listindex property. Invalid property value. This is under private sub command button 43.
What number should put 'month´
Vba.Dateserial(2020, I,1), " ? "
Please help me.
sorry but , how to put in the collected cell non Text format 13-dec-2022 but Date Format 13/12/2022
Can you share the file example?
I made it in MS Access but I get error 13(Type mismatch) in line Set btn...
Last_Date = VBA.Day(VBA.DateSerial(Year(First_Date), Month((First_Date) + 1, 1) - 1)
For this code getting Compile error
Thank you
My calendar is not working