Which Microsoft are u using brother, coz am using 2010 and I was only able to apply on that fast date of the command button but in applying to all buttons it failed
Me gustó bastante, quiero usarlo en mi proyecto, ya lo tengo y lo corregí en algunos puntos necesarios, gracias por tomarte el tiempo de desarrollar algo como esta herramienta
Hello Priyendra! First of all, I really like your lessons, method and logic used. I'm following the development of "fully functional dynamic calendar control in VBA" and in part 2, in Sub Show_Date I was able to insert day "1", but the others do not appear in the CommandButtons. I'm using Excel 2010. I wonder if you imagine what's taking place so that command lines do not respond as demonstrated in your video
The issue is the commandbuttons name, if the cmnd buttons in ur project are named something else or initial buttons before calendar are already given those names then it won't work
I'm a beginner and I really appreciate tutorial videos like this. I tried coding this but I got stuck on show date, it says that wrong number of assignments.
Gold on Previous April 2019, March 2019, February 2019, January. 2019, December 2018, November 2018, October 2018, September 2018, August 2018, July 2018
Hello PK Thank you very much for the tutorial and for making the code available. I tried to use your calendar but I encountered the following format problem: the dates of the months of March, May, October and December have a format like this: 20-Okt-2020 which unfortunately is not recognized as Microsoft format (string?). All the days of all other months have the format 1. Apr 20 which works well. Can you help me please? Thank you Tiziano
After this code: Sub ButtonClick(btn As MSForms.CommandButton) With btn If .Caption "" Then Me.TextBox1.Value = .Caption & "-" & Left(Me.CmbMonth.Value, 3) & "-" & Me.CmbYear.Value Unload Me End If End With End Sub I have inserted this: Private Sub TextBox1_Change() 'Ny TextBox1.Value = Format(TextBox1.Value, "dd/mm/yyyy") End Sub
Hi I managed to follow all the stages but failed to read the on part 2 above i=1 to 42 kindly assist or if there's any other way I can access them I'll appreciate from zimbabwe
I have a problem. My week starts with Monday and my issue is at 2022-05-01. It falls on sunday. I modified your code a bit to fit with the week starts with Monday like this: For i = 1 To 42 Set btn = Me.Controls("CommandButton" & i) If VBA.Weekday(first_date) - 1 = i Then btn.Caption = "1" End If Next i So the problem comes when the first day of the month falls on Sunday. It shows nothing on the buttons. where the numbers should be. Solution?
Hi sir, I tried your calendar in excel. My last year is 2043 but when I press next it is still going to 2044, 2045 and the same goes to previous too. Please let me know where is the mistake as I have typed the codes same as it was shown in the tutorials.
Microsoft Visual Basic for Applications --------------------------- Compile error: Wrong number of arguments or invalid property assignment --------------------------- OK Help --------------------------- bro, help me on this when I was making a calendar too following your helpful tutorial
when i across the sub show_date() When i put first date is appear in massage box but last_date is not showing it is showing errors massage . "Wrong number of argument or invlaid property assignment " why it showing avobe massage . Kindly i want to your email .....
Hello Priyendra! First of all, I really like your lessons, method and logic used. I'm following the development of "fully functional dynamic calendar control in VBA" and in part 2, in Sub Show_Date I was able to insert day "1", but the others do not appear in the CommandButtons. I'm using Excel 2010. I wonder if you imagine what's taking place so that command lines do not respond as demonstrated in your video
How can anyone dislike your videos. They are amazing. Learned so much from you! Thank you very much!
Thanks for your valuable feedback and support
@@PKAnExcelExpert , dear I've runtime error 13. can you plz helo me?
Since Microsoft removed the DTP this is a breath of fresh air. I am so pleased to have found this tutorial.
Thanks for your valuable feedback
Outstanding calendar control; possible uses for this are endless, thank you for sharing this.
very useful and important " Fully Functional Dynamic Calendar Control in VBA (Part-1-3) " thank you for sharing !
Glad it was helpful!
Which Microsoft are u using brother, coz am using 2010 and I was only able to apply on that fast date of the command button but in applying to all buttons it failed
10 out 10 outstanding !! recommend to all. Thank you, God bless!
Thank you so much
Me gustó bastante, quiero usarlo en mi proyecto, ya lo tengo y lo corregí en algunos puntos necesarios, gracias por tomarte el tiempo de desarrollar algo como esta herramienta
gracias por ver el video
Excellent Tutorial. Thanks for sharing.
Thanks for your valuable feedback
dear teacher, great work. Thank you...
thank you so much
God bless you
Thank you so much the video is very helpful
I can only say thank you
Most welcome
Working well so far. Thanks
Thanks for your valuable feedback
THANK YOU SO MUCH!!!!!!!!!
Most welcome
thank you..
You're most welcome
Thanks, great job !
Thanks for your valuable feedback
Very very nice 😊👍
Thanks for your valuable feedback
Hello Priyendra!
First of all, I really like your lessons, method and logic used.
I'm following the development of "fully functional dynamic calendar control in VBA" and in part 2, in Sub Show_Date I was able to insert day "1", but the others do not appear in the CommandButtons.
I'm using Excel 2010. I wonder if you imagine what's taking place so that command lines do not respond as demonstrated in your video
yes I am also the same, and what I follow is not the same as the one in the tutorial
Hello sir did u get the soln of this?
@@imamnuriadin674 hello sir did u get the soln of this
The issue is the commandbuttons name, if the cmnd buttons in ur project are named something else or initial buttons before calendar are already given those names then it won't work
@@amulyabindal Hello Priyendra!
Thanks for the feedback, I will check the project and see if there is this kind of divergence in the names.
Outstanding work over there. Thanks helped a lot. Just gained +1 Subscriber :)
Thanks for your valuable feedback and subscription
Super!
Thanks for your valuable feedback
Thank for sharing your knowledge with everyone, Is there way we can use this calendar in Excel Add on option?
excellent video tutorial
thanks a lot for your efforts
please can u upload a video tutorial regarding hospital management.
thanks in advance.
Thanks for your valuable feedback. I will definitely try to make such video
Hello,thanks for this awesome video.
I have followed the entire tutorial but my calendar is not showing any dates.Please help
your coding is very good, where should I learn first?
Kindly make a video on entering date in a cell using such calendar form, also it went down to the next cell after entering that date
Thank you so much sir I co up with one Nice tutorialt wonders in my sleep and can't even make a soft.... No I did not
Great calendar, thank you. Is there anyone who can build week number in this? The week starts on Mondays.
Thanks, so far
16:47
Very nice calendar, it is possible to activate the calendar from the personal.XLSB folder.
My Sub Show_Date is not working.
It is said (Compile error: Wrong number of argument or invalid property assignment)
have you got the reason for this error?
coz I am also receiving this problem.
Me too getting same issue.actually i work first tym but when i practice next tym iam getting this issue.
@@aarifbobade2403 me too same error, did you solve the problem, actually I am not a developer but learning VBA excel
Same Problem
hi please guide me on how can I be an expert in VBA too, I mean which book should I read to be an expert in less time.
Hello sir iam getting error in last date coding but iam using same coding what you write.your videos are very good.
Could it be activate the days of the previous month and the days of the month after?
I'm a beginner and I really appreciate tutorial videos like this. I tried coding this but I got stuck on show date, it says that wrong number of assignments.
When I'm resting the userform the txtbox value clears but the date picker loads again instead of shutting down. Any help with this?
Hi bro calender program is have dovut which type picture use next button previous button
I have downloade your calender but how can I use it in a userform with vba
What if I like monday to be first day of week?
'============ Clear All button
For i = 1 To 42
Set btn = Me.Controls("CommandButton" & i)
btn.Caption = ""
Next i
'====================
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
Hi Sir. My show_dates are not working first date is returning a 00:00:00 and last date is a blank. Thanks for the good videos.
How to add a calender a option
Gold on Previous April 2019, March 2019, February 2019, January. 2019, December 2018, November 2018, October 2018, September 2018, August 2018, July 2018
Hello PK
Thank you very much for the tutorial and for making the code available.
I tried to use your calendar but I encountered the following format problem: the dates of the months of March, May, October and December have a format like this:
20-Okt-2020 which unfortunately is not recognized as Microsoft format (string?).
All the days of all other months have the format 1. Apr 20 which works well.
Can you help me please?
Thank you
Tiziano
After this code:
Sub ButtonClick(btn As MSForms.CommandButton)
With btn
If .Caption "" Then
Me.TextBox1.Value = .Caption & "-" & Left(Me.CmbMonth.Value, 3) & "-" & Me.CmbYear.Value
Unload Me
End If
End With
End Sub
I have inserted this:
Private Sub TextBox1_Change() 'Ny
TextBox1.Value = Format(TextBox1.Value, "dd/mm/yyyy")
End Sub
Hi sir i have compile error for wrong number of arguments or invalid property assignment
sir ap online class karate he kia
why in some months, the date is not in a right place? i mean not follow the order 1,2,3...and some also skip order
How to purchase dynamic calendar
Link is given in video's description box or email us at info@PK-AnExcelExpert.Com
Hi I managed to follow all the stages but failed to read the on part 2 above i=1 to 42 kindly assist or if there's any other way I can access them I'll appreciate from zimbabwe
I have a problem. My week starts with Monday and my issue is at 2022-05-01. It falls on sunday. I modified your code a bit to fit with the week starts with Monday like this:
For i = 1 To 42
Set btn = Me.Controls("CommandButton" & i)
If VBA.Weekday(first_date) - 1 = i Then
btn.Caption = "1"
End If
Next i
So the problem comes when the first day of the month falls on Sunday. It shows nothing on the buttons. where the numbers should be.
Solution?
Enabled for 32 and 64 bits????
Im getting error by wrong number of arguments or invalid property assignment pls help me out
but sir i complete the form error is sub or function not define (compile Error)in mothbox code (call show date) r highlight
Excellent sir , may plz guide as I am facing this error msg
Run time error, could not find the specified object.
Sir, some error msg is coming while running the code.
Hi sir i am getting error , only 1 date it showingas per you 2nd lecture , others date's not showing, kindly help me
First_data line showing compile error : expected : list separator or ) what can I do?
Please download the sample excel file from the link given in video's description box. you can see all the codes there.
there's a mismatch when I run the code. How can I fix it
Hi Sir i am getting error on set btn = me.Controls("CommandButton",&j) Please help
Me too
Hi sir did you get the soln of this issue
dear I've runtime error 13. can you plz help me?
Hi sir, I tried your calendar in excel. My last year is 2043 but when I press next it is still going to 2044, 2045 and the same goes to previous too. Please let me know where is the mistake as I have typed the codes same as it was shown in the tutorials.
Doesn't show the dates.. Can you help me
How can move run time error '13''
Type mismatch
Microsoft Visual Basic for Applications
---------------------------
Compile error:
Wrong number of arguments or invalid property assignment
---------------------------
OK Help
---------------------------
bro, help me on this when I was making a calendar too following your helpful tutorial
when i across the sub show_date()
When i put first date is appear in massage box but last_date is not showing it is showing errors massage . "Wrong number of argument or invlaid property assignment " why it showing avobe massage . Kindly i want to your email .....
i have the same error , is there is a solution?
in show date () date number is not showing
i m getting error while coding for Last_date = VBA.DateSerial(Year(first_date), Month(first_date) + 1, 1) - 1
it is incomplete due to this kindly help
in First_date, errer 13 (First_Date = VBA.CDate("1_" & Me.ComboBox1.Value & "_" & Me.ComboBox2.Value)
is not working
Sub Show_Date()
it says (Run-time error '-2147024809 (80070057)':
Could not find the specified object
Seeking for your help
your all videos have errors
nothing helpful
Hello Priyendra!
First of all, I really like your lessons, method and logic used.
I'm following the development of "fully functional dynamic calendar control in VBA" and in part 2, in Sub Show_Date I was able to insert day "1", but the others do not appear in the CommandButtons.
I'm using Excel 2010. I wonder if you imagine what's taking place so that command lines do not respond as demonstrated in your video
Hei, I also experience the same thing. Have you figure it out?