Thanks another good and useful application Is it possible to move shapes with the mouse and dates are updated as you have solved earlier? predetermined printer selection as well as A4, A3, Letter
HI and thanks for your comment. Concerning drag and drop shapes with date changes, I show you that here: ua-cam.com/video/aB2z1qKUI4A/v-deo.html Once you set your printer settings, they will remain until you change them. If you need more than one printer setting, you can do that via VBA on a per-sheet basis. I hope this helps and thanks so much.
Hi and thanks, The calendar will accommodate up to 7 projects per day however, you can expand the rows in the days to accommodate as many projects as you like. I hope this helps and thanks so much.
Hi, the Field3 in ProjectFrm and Field 5 is not working, I dont know if its because Im from Spain or if the version on my excel is old (Microsoft Office Standard 2019), or because you did it from a Apple computer and I have Windows. I dont know how to fix it Thanks
Hi Marlo, thanks for your comment. I also use a Windows, so that would not be a problem and your version of Office is just fine. The reason for the issue is that the Date Picker I used probably is not working for the Date Formats on your computer. I have been getting some complaints from this and I really must developer a date picker, for userforms that work for every single Date format. Just to prevent the bug, you can disable the Date Picker If you go into the VBA Code behind this form, there is an event on Enter that looks like this Private Sub Field5_Enter() With CalendarFrm .Left = ProjectFrm.Left + ProjectFrm.Field5.Left .Top = ProjectFrm.Top + ProjectFrm.Field5.Top + 43 .Show End With End Sub If you remove this code, the issue will go away (however the date picker will not display) Creating a date picker that works for every single date format is high on my priority list. I hope this helps and thanks so much.
Hey Randy !!! On your VBA for beginners series, could you make a video on how to correctly save(an invoice, sales order...) as PDF. Especially how to size it and center it. As I have seen in your tutorials it only takes few lines of code to turn anything into a pdf file but the problem is sometimes if I define a print area and try to save it as a PDF, I run into some problems: like the size, it splits into two pages, it is not centered etc... I hope you understand me and I am looking forward to see a training on that.
Hi, converting your brilliant project in italian. When I try to insert or edit a date, the calendar picker doesn't work and I get a Type mismatch (Error 13). Any solution for this? Thank you and congratulations!
Hi and thanks so much. You may want to remove this date picker and replace it with an add-in that I have developed here ua-cam.com/video/1JtbErLgOnA/v-deo.html I hope this helps and thanks so much.
Think I Found a Bug! It seems that if you delete any of the first 3 entries of your database (A3:O6) from within the program, the Calendar_Refresh fails. I am a newbie to VBA however, I shall endeavor to find a fix. Any help would be appreciated.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Grat. I hope you consider make the same calendar for doctors in a clinic or hospital. For more than 3 years you promised to put that in your consideration, and I don't know when that will happen
Hello, thank you for your videos. I searched carefully, but you never treated a service company manager like a web agency or architect. Each project has a price, will be attached to a client, and billing dedicated to each project (several invoices per project, with reminders and calculation of the remainder to be invoiced). With a dashboard, with paid and unpaid invoices, reminders to be made.....etc. Thank you for guiding me to one of your tutorials that deals with this type of service.
HI , thanks for the information. I have parts of this however all of this combined would be a custom job. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Maybe there is something on my computer that is causing this, but I don't think so. It seems that the calendar is NOT showing all the holidays correctly. Just look in November or December. None there. I've tried to see what's going on, but it seems that the returned results of the Find statement in VBA is not correctly locating those holidays???? Can anyone else confirm this to be the case, or is it just a matter of my machine doing something stupid? Awesome video by the way!
Most likely its due to date formats for your regional settings. You will want to make sure that the date formats in Excel, including Holidays, WeekStart, WeekEnd, and all of the Project Start and End dates match exactly as your system. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I'm getting the same thing as you. Nothing past september is showing. I did add a couple of them to see if it works and they don't even show. Great templet for projects but not so much for holidays, events and birthday dates. Thanks Randy for sharing your work.
Thanks so much Jorge. it is a 'Date Format' issue. Once all of your date formats are correct, it will work quite well. I hope this helps and thanks so much.
@@ExcelForFreelancers Just FYI, this is on the file that you posted. I've gone in and checked the format for ALL the dates, and it's still not working. However, I recreated it from scratch and it works. On the file you provided, most of the dates work, except the later ones, or ones that are added later. I'm wondering if it wouldn't be better to change the find in VBA to convert the date to a string so that it is a little more reliable????
@@ExcelForFreelancers Hi Randy, I did check that many times and I can't make it to work! The downloaded file only shows August and September Holidays. Not showing anithing else nor new dates added. Thank for the response.
HI and thanks Peter, there are projects loaded and you can check the database to see if there are any filters set. Please make sure to follow the entire training to help you understand the projects and userform. I hope this helps and thanks so much.
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
This is absolutely amazing. Looking forward to learn yet another new set of skills from this. Keep it up!
Awesome. I am so happy to hear that. Thanks so much Robert. Thank you for your Likes, Shares & Comments. It really helps.
@ExcelForFreelancers Welcome Randy. Always a pleasure 🙏
Thanks another good and useful application Is it possible to move shapes with the mouse and dates are updated as you have solved earlier? predetermined printer selection as well as A4, A3, Letter
HI and thanks for your comment. Concerning drag and drop shapes with date changes, I show you that here: ua-cam.com/video/aB2z1qKUI4A/v-deo.html
Once you set your printer settings, they will remain until you change them. If you need more than one printer setting, you can do that via VBA on a per-sheet basis.
I hope this helps and thanks so much.
Again, a wonderful solution! Thank you.
Unfortunately, only 6 projects can be shown....
Is there a solution for more than 6 projects?
Hi and thanks, The calendar will accommodate up to 7 projects per day however, you can expand the rows in the days to accommodate as many projects as you like. I hope this helps and thanks so much.
Thank you Randy for this amazing video.
For sure, you are very welcome Syed. I am happy to help and share
Hi, the Field3 in ProjectFrm and Field 5 is not working, I dont know if its because Im from Spain or if the version on my excel is old (Microsoft Office Standard 2019), or because you did it from a Apple computer and I have Windows. I dont know how to fix it
Thanks
Hi Marlo, thanks for your comment. I also use a Windows, so that would not be a problem and your version of Office is just fine. The reason for the issue is that the Date Picker I used probably is not working for the Date Formats on your computer. I have been getting some complaints from this and I really must developer a date picker, for userforms that work for every single Date format. Just to prevent the bug, you can disable the Date Picker
If you go into the VBA Code behind this form, there is an event on Enter that looks like this
Private Sub Field5_Enter()
With CalendarFrm
.Left = ProjectFrm.Left + ProjectFrm.Field5.Left
.Top = ProjectFrm.Top + ProjectFrm.Field5.Top + 43
.Show
End With
End Sub
If you remove this code, the issue will go away (however the date picker will not display)
Creating a date picker that works for every single date format is high on my priority list.
I hope this helps and thanks so much.
Is this a calendar that can be shared with others, and does it work with Excel Web version (so I can access it on mobile) or only on Desktop version?
Hi and thanks so much. Based on your requirements, Google Calendar would be your best bet. I hope this helps and thanks so much.
Hey Randy !!!
On your VBA for beginners series, could you make a video on how to correctly save(an invoice, sales order...) as PDF. Especially how to size it and center it. As I have seen in your tutorials it only takes few lines of code to turn anything into a pdf file but the problem is sometimes if I define a print area and try to save it as a PDF, I run into some problems: like the size, it splits into two pages, it is not centered etc...
I hope you understand me and I am looking forward to see a training on that.
Keita... anything for you. It's a great idea and I will get it done. Thanks again for your continued support
We are a 100% Microsoft house not allowed to use Google anything per customer requirements. I look forward to today's session.
@@ExcelForFreelancers Thanks so much.
nice work thanks
For sure, you are very welcome and thanks so much Rob. Much appreciated
Hi, converting your brilliant project in italian. When I try to insert or edit a date, the calendar picker doesn't work and I get a Type mismatch (Error 13). Any solution for this? Thank you and congratulations!
Hi and thanks so much. You may want to remove this date picker and replace it with an add-in that I have developed here
ua-cam.com/video/1JtbErLgOnA/v-deo.html
I hope this helps and thanks so much.
Think I Found a Bug! It seems that if you delete any of the first 3 entries of your database (A3:O6) from within the program, the Calendar_Refresh fails. I am a newbie to VBA however, I shall endeavor to find a fix. Any help would be appreciated.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Grat. I hope you consider make the same calendar for doctors in a clinic or hospital. For more than 3 years you promised to put that in your consideration, and I don't know when that will happen
Hi and thanks very much. I do have that already here: ua-cam.com/video/9oebyN-ivhU/v-deo.html
I hope this helps and thanks so much.
Hello, thank you for your videos.
I searched carefully, but you never treated a service company manager like a web agency or architect.
Each project has a price, will be attached to a client, and billing dedicated to each project (several invoices per project, with reminders and calculation of the remainder to be invoiced).
With a dashboard, with paid and unpaid invoices, reminders to be made.....etc.
Thank you for guiding me to one of your tutorials that deals with this type of service.
HI , thanks for the information. I have parts of this however all of this combined would be a custom job. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
Maybe there is something on my computer that is causing this, but I don't think so. It seems that the calendar is NOT showing all the holidays correctly. Just look in November or December. None there. I've tried to see what's going on, but it seems that the returned results of the Find statement in VBA is not correctly locating those holidays???? Can anyone else confirm this to be the case, or is it just a matter of my machine doing something stupid? Awesome video by the way!
Most likely its due to date formats for your regional settings. You will want to make sure that the date formats in Excel, including Holidays, WeekStart, WeekEnd, and all of the Project Start and End dates match exactly as your system.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I'm getting the same thing as you. Nothing past september is showing. I did add a couple of them to see if it works and they don't even show. Great templet for projects but not so much for holidays, events and birthday dates. Thanks Randy for sharing your work.
Thanks so much Jorge. it is a 'Date Format' issue. Once all of your date formats are correct, it will work quite well. I hope this helps and thanks so much.
@@ExcelForFreelancers Just FYI, this is on the file that you posted. I've gone in and checked the format for ALL the dates, and it's still not working. However, I recreated it from scratch and it works. On the file you provided, most of the dates work, except the later ones, or ones that are added later. I'm wondering if it wouldn't be better to change the find in VBA to convert the date to a string so that it is a little more reliable????
@@ExcelForFreelancers Hi Randy, I did check that many times and I can't make it to work! The downloaded file only shows August and September Holidays. Not showing anithing else nor new dates added. Thank for the response.
Good evening
Thanks so much for joining us. I hope you have enjoyed the video
A mobile version sounds good too
Hi and thanks Joe. Great idea and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
EK naam PE KAI SARE DATA column se row me kayese kare
Hi and thanks very much. You can set up a named range for that. Thank you for your Likes, Shares & Comments. It really helps.
When I click edit add projects the form loads but there are no projects listed this was a very early down load is there an update
HI and thanks Peter, there are projects loaded and you can check the database to see if there are any filters set. Please make sure to follow the entire training to help you understand the projects and userform. I hope this helps and thanks so much.