Hi, Randy! I just installed the shape-based calendar and it is working very well. You did a phenomenal job with the code accounting for a number of different situations, and also with the design details! Thank you so much for sharing this.
Thanks so much Celia, I do love the shape-based but they can be a bit tricky to work with sometimes. Of course you are an expert, so nothing is tricky for you. I have a new take on a cell-based calendar training coming up in a few days. Similar to the double calendar when you book flights. I hope you will like it.
@@ExcelForFreelancers I wil check that new video. I have been playing with the shape based calendar version from this video, making a few tweaks and it's working great!
HI randy, Thanks very much for the Calendars. Just a quick question ? Can we bring up/ call any of these calendars within a VBA form ? Thanks in advance . Martin
Hi and thanks for your comment. You would want to use a form-based date picker when adding calendars to existing userforms, and not the shape-based calendars, which are only for sheets. I hope this helps and thanks so much.
I love your three different calendars and appreciate you preparing. It is possible to use one of these calendars on this file I created which is a 4 week based form, but my company changed accounting periods from a 4 week to a monthly based? The 5th week would change based on the calendar of the year and month and could I tie that 5th week to one of the 3 calendars you created? Thank you.
Hi Ken, thanks so much for your message. The calendars are all open and unlocked and you can make any changes you like. If you would like to have someone customize this for you 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. Create a new post with the words PAID JOB and post your detailed requirements, 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
Randy, I'm missing some of the info you show in the Developer tab/Visual Basics area. How can I communicate with you to show you what I'm speaking about?
Hi Ken, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Make sure to download my application using the links in the description. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi Nora, if you are on a browser version this would not work, also if you are on a Mac there are some limitations. 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
Respected sir, I seen your few of videos of you did one. I inspired a lot and I started practice in beginning am facing little bit to do or complete the task. I to learn some basics of programming of VBA.. Sir can you give a link of your 1st video of VBA. I hope it is helpful to me and who are watching your valuable videos they also gain from you knowledge..... thanking you sir
HI thanks so much. All of my videos are on my channel here: ruclips.net/user/ExcelForFreelancers In the future I will have some basic VBA classes and videos as well so please keep watching. Also please feel free to join our Facebook Group, with thousands excel experts here: bit.ly/groupexcel
Hi Vicky, you can use the Userform Date Picker form for existing userform (not the shape-based and not the sheet-based calendars) I hope this helps and thanks.
Hi Randy! Thank you so much for the video! I have a question: when I use the code it's giving me the Run-time error '1004' Method 'Range' of object '_Worksheet' failed when I add multiple cells to the code. I added from cell B3 to cell B67 and it works perfectly but when I try to add cell B68 or another one, it gives me the error mentioned above. Any ideas of how to resolve this?
Hi Junior, 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 40,000 Members who would love to help you with this. Thanks so much.
Hi, just found your channel and it has a really great content; You have done a very good job, congrats. I would like to know if there is a way to link any of these calendars to a pivot chart so I don't have to use slicers for the dates.
Hi Vladimir thanks for the comment. You could assign the Form or Shape based calendar to any cell or Active X or Form Control. If you use a Form Control you still may want to use a linked cell, even in it's header. Most pivot tables have limits to them as well. You can assign a macro to any cell within your pivot table to open on cell selection which can be helpful in this case. I hope this helps. Please feel free to join our Facebook Group as well. bit.ly/groupexcel
Hi Kunalj thanks very much for your comment. I have actually already created that in a series of videos in my Employee Manager. You can find that right here: ruclips.net/video/w8gVLQ7ixfA/видео.html Thank you for your Likes, Shares & Comments. It really helps.
I tried downloading the "Free" workbook for three types of pop-up calendars. And nothing arrived in my email. ???? It seems I need to purchase 200 workbooks in order to get the "free" calendar workbook. ????
Hi Ron, certainly you do not need to make the purchase. Free is Free. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi and thanks it would be difficult to know unless I saw your sheet and your goals. Can you please share a screenshot of what you are trying to do in 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.
Hi Hilary, 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 50,000 Members who would love to help you with this. Thanks so much.
Hi Peter this should work just fine, however if you do run into any issues just post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel so that our members can help you. Thanks very much.
Request help: How can I use the in-cell-calendar for a range of cells in my spreadsheet? Thank you. (ex: I need to input a series of dates in cells A20:M20.)
Hi yes you can Cecil, you can set the range to anything you like. Just use a hidden cell to save the range you have selected, and when a user selects a date in that calendar, add the date to whatever range the user has selected. For more details please post your entire requirements in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks so much.
Hi and thanks, I believe so however there may be code updates required You can check for the type of updates for a Mac here: www.macexcel.com/ I hope this helps and thanks so much.
Like the calendar a lot. Ran into an unexpected linking problem: (Using Excel 2013 on native Windows 10 Toshiba laptop.) After using the calendar awhile, I began getting a can't link error, although everything in my workbook worked. Tracked it down to a link between my workbook, and the downloaded workbooks used during install. The linking error happened because I moved those files, thinking they were not needed. But as it turned out, 3 Excel Calendars.xlsm is linked, and through it DatePicker.xlsm is linked. But...when I examine links in my workbook, or in the download workbook, the following is found: If I look at Inquire tab:Workbook Relationship, the diagram shows these links as existing. If I look at Data tab:Edit Links, no such links are shown in order to break them. (When I return the download workbooks to their original location, the error stops. Either way, everything works.) In my workbook, I have CalPopUp as Sheet3 (hidden) and Popup_Calendar Module, so I would think these are enough. Yes? This is important, as the finished workbook will reside on someone else's computer. --- Any suggestions? --- Thanks, Doug
Hi Doug, I do understand that issue. Sometimes when moving over the calendar the macros assigned don't always get written properly to the new calendar. The CalPopUp sheet contains a calendar as a backup, so this way if your calendar on your sheet gets deleted the backup is copied over (you could manually do this as well) (You just don't want two calendars on the same sheet) 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
Hi Mike, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
I wanted to create a calendar macro so I could put the date in whatever cell I select. My version of Excel, which is the latest, does not have the Microsoft Date Control. What can I do? Thanks!
Hello! I have an error on calendar when I choose month. In Private Sub Build_Calendar() If i < CInt("01/" & Weekday((CB_Mth.Value) & "/" & (CB_Yr.Value))) Then the error is - Data type error
HI make sure that the values in your fields are numbers and that the field names are correct 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
@@ExcelForFreelancers HI make sure that the values in your fields are numbers and that the field names are correct. You think about your file 3_Excel_Calendars? I am not change these file. But error occur immediately when I click on E7 cell. Type mismatch runtime error 13.
Dear Randy, your video so cool. I want to implemen special Timer 'cutdown' into my excel file. But I faced with issues that Timer connected to cell. When user open the file and based on his name Timer 'cutdowm' must set time up ( 10 min) and start to work. Here is I found the issue: when user making modification in cell Timer is not working.....After to avoid this I try to create my own timer and set up time by formula....this solution works but new issue poped up: this kind of timer works only in one sheet due to textbox.controlsouce coneted only to one sheet to one cell. If i chose other sheet my Timer started but not counting time. Could you help me please, with Timer counting creation which will work in all worksheets and not freazze or stoped and when user activate each o cell for write some data or text into cell? Thank you in advance. Best regard. Best
Hi you would want to make sure to reference the full sheet in the control source and not just the cell (search google for Excel Control source sheet reference) 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
Hola y gracias. A veces esto puede aparecer en un teléfono, sin embargo, si recibe el correo electrónico en la computadora, no debe estar en blanco. Leí el correo electrónico que me enviaste y ese correo electrónico no estaba en blanco, así que descárgalo en tu computadora y debería funcionar bien.
Hi Colby, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Can u also make a video on how to create a marquee text in excel without using Microsoft webbrowser as webbrowser doesn't work in Excel 2013 & 2015. I have tried but it doesn't smoothly animate the text because it is reflected after every second and I am not getting how to reflect in milliseconds for smooth animation.
Hi Max, 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 30,000 Members who would love to help you with this. Thanks so much.
Hello this in regards with the popup Calendar that's available for download. After downloaded the files "DATE PICKER SHAPE Based" in that the 27th date or the last row 4th Column doesn't work properly for eg: if we select 27 it shows next date that's 28. Why is it?? Can you please help with the solution for it?? Thank you
Hi sorry to hear about that it is not working correctly. I would like to take a look at that specific instance so i can see the issue. Perhaps you can join our Excel Facebook Group here: bit.ly/groupexcel , and post your workbook so me and other Excel members can fix the issue for you. Thanks so much.
Hello thank you for the reply. if its not much of the trouble the group that you mention is linked with facebook login isn't it? But unfortunately i don't use facebook. So, if its not much to ask can you provide the solution on this platform itself please. This is the link you had provided to one Kellie with this link (bit.ly/3_Cal_WbDl) which i also downloaded & found this problem, please if you help on this will be of great helps. Hope to hear from you asap. Thank you in advance.
Hi thanks for your comment. I would recommend using the Form Based Date picker as the shape based pick may have issues in certain workbooks. Thanks for your patience.
How to make the popup calendar close by pressing Esc button. Instead of using mouse to click on close button, is there any way to close the popup calendar close by pressing Esc button on keyboard. Thanks.
Its a good question. There are a few options. Please post the question in our group so we can get many different possible solutions. Http://bit.ly/groupexcel
Please be patient, as I have many requests and tasks as well as responsibilities and I have not been able to double check on the best solution for you just yet.
I had used the first one which is form calendar. But when i select a date and again visit the cell to change date, the form calendar is automatically switching to today's. Pls tell me how to stop the calendar from switching to today's month. Pls reply @Excel for freelancers
The Form Calendar (first One) will always have a small square around the current date however you are free to enter any date you want. The current date is not automatically entered into the cell date.
Excel For Freelancers I wants to know how to stop the calendar from switching to current month and year. When i enter a date in different month and year, the calendar should fix to that month and year if i again visit that cell.
Also if you go into the code for the calendar (double click the calendar) you see: ThisDay = VBA.DateTime.Date Change to: ThisDay = Sheet1.Range("A1").Value Make sure instead of A1, you use the cell that contains your date
Excel For Freelancers The above one has solved the issue. But i am getting am error whenever the linked cell is empty. If there is already a date in that cell then it is working fine, But if the cell is empty it is not working because the macro is not getting which month it should display. Pls tell how to fix that. If a date is entered the calendar must show according to that month and year but if the cell is empty the default should be set to today's date. Thanks in advance.
Hi it's hard to tell what exactly is the cause however if you join our group and upload the file or screenshot for sure we can help you. Please join our Facebook group here: bit.ly/groupexcel Thanks so much.
shafiqul islam Hi thanks for your message. You can download the complete workbook with code from here : www.excelforfreelancers.com/3-excel-calendars-download
Hi Michal, 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 40,000 Members who would love to help you with this. Thanks so much.
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, I have created a Facebook group with 7000 Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
2007 Should work for most of my applications. (I design everything in 2010). If you have a specific issue we can help in our Excel For Freelancers Facebook Group. (bit.ly/groupexcel )
You guys made a mistake, instead of having 3 excel calendars, the download for the forms and the tutorials. You have "Fade Out Messages" workbook and tutorials In both places 🤔. Can you fix this. I would like to learn how to do calendars in excel.😊
Hi thanks so much. Yes I did see some issue with that (before it was working but the mail service is making some changes) Anyways I will get it fixed right away, but you can download the workbook directly from this link: bit.ly/3_Cal_WbDl
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
Hi, Randy! I just installed the shape-based calendar and it is working very well. You did a phenomenal job with the code accounting for a number of different situations, and also with the design details! Thank you so much for sharing this.
Thanks so much Celia, I do love the shape-based but they can be a bit tricky to work with sometimes. Of course you are an expert, so nothing is tricky for you. I have a new take on a cell-based calendar training coming up in a few days. Similar to the double calendar when you book flights. I hope you will like it.
@@ExcelForFreelancers I wil check that new video. I have been playing with the shape based calendar version from this video, making a few tweaks and it's working great!
HI randy, Thanks very much for the Calendars. Just a quick question ? Can we bring up/ call any of these calendars within a VBA form ? Thanks in advance . Martin
Hi and thanks for your comment. You would want to use a form-based date picker when adding calendars to existing userforms, and not the shape-based calendars, which are only for sheets. I hope this helps and thanks so much.
Awesome! Well explained and the Shape date Picker is brilliant and easy to put into a workbook with the detailed instructions. Thanks!
For sure, you are very welcome Adrian
Good lesson Randy! Working through your 150 Excel Workbook Library.
Awesome, thanks so much Rob. I do appreciate that.
I love your three different calendars and appreciate you preparing. It is possible to use one of these calendars on this file I created which is a 4 week based form, but my company changed accounting periods from a 4 week to a monthly based? The 5th week would change based on the calendar of the year and month and could I tie that 5th week to one of the 3 calendars you created? Thank you.
Hi Ken, thanks so much for your message. The calendars are all open and unlocked and you can make any changes you like. If you would like to have someone customize this for you 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. Create a new post with the words PAID JOB and post your detailed requirements, 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
Randy, I'm missing some of the info you show in the Developer tab/Visual Basics area. How can I communicate with you to show you what I'm speaking about?
Specifically I don't have the "Form Calendar" tab you show in your video.
Hi Ken, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Make sure to download my application using the links in the description. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
I am using Microsoft Office 365 and I do not have a Form folder in VBA. Was this removed in Microsoft 365?
Hi Nora, if you are on a browser version this would not work, also if you are on a Mac there are some limitations. 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
Hello sir , ❤️
Can I use these cal... In userform?
Hi and thanks. The one calendar that is made in a userform can be used in a userform, the other two cannot.
I hope this helps and thanks so much.
@@ExcelForFreelancers fine sir
Thanks
Have a great day
Respected sir, I seen your few of videos of you did one. I inspired a lot and I started practice in beginning am facing little bit to do or complete the task. I to learn some basics of programming of VBA.. Sir can you give a link of your 1st video of VBA. I hope it is helpful to me and who are watching your valuable videos they also gain from you knowledge..... thanking you sir
HI thanks so much. All of my videos are on my channel here: ruclips.net/user/ExcelForFreelancers
In the future I will have some basic VBA classes and videos as well so please keep watching.
Also please feel free to join our Facebook Group, with thousands excel experts here: bit.ly/groupexcel
can I use this calendar 'within' an existing user form? I have a booking user form and would like to be able to select a date from a pop up.
Hi Vicky, you can use the Userform Date Picker form for existing userform (not the shape-based and not the sheet-based calendars)
I hope this helps and thanks.
Hi Randy! Thank you so much for the video! I have a question: when I use the code it's giving me the Run-time error '1004' Method 'Range' of object '_Worksheet' failed when I add multiple cells to the code. I added from cell B3 to cell B67 and it works perfectly but when I try to add cell B68 or another one, it gives me the error mentioned above. Any ideas of how to resolve this?
Hi Junior, 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 40,000 Members who would love to help you with this. Thanks so much.
Hi, just found your channel and it has a really great content; You have done a very good job, congrats. I would like to know if there is a way to link any of these calendars to a pivot chart so I don't have to use slicers for the dates.
Hi Vladimir thanks for the comment. You could assign the Form or Shape based calendar to any cell or Active X or Form Control. If you use a Form Control you still may want to use a linked cell, even in it's header. Most pivot tables have limits to them as well. You can assign a macro to any cell within your pivot table to open on cell selection which can be helpful in this case. I hope this helps. Please feel free to join our Facebook Group as well. bit.ly/groupexcel
Sir can we use the userform calendar in corel draw please tell me
HI and thanks very much. This only works in Excel. I hope this helps and thanks so much.
@@ExcelForFreelancers ok thank you sir can you provide popup calendar coding for corel draw software
Randy I need your help to put such a calendar for attendance tracking of an employee.
Hi Kunalj thanks very much for your comment. I have actually already created that in a series of videos in my Employee Manager. You can find that right here: ruclips.net/video/w8gVLQ7ixfA/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
Nice tutorial!
PS: I usually show calendar also on double click to make sure it is triggered
Thanks very much. Double click is also a great option i have used as well.
I tried downloading the "Free" workbook for three types of pop-up calendars. And nothing arrived in my email. ???? It seems I need to purchase 200 workbooks in order to get the "free" calendar workbook. ????
Hi Ron, certainly you do not need to make the purchase. Free is Free. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Coding meant for calendar to be called from a sheet. How do I call if from another form whit a date entry?
Hi and thanks it would be difficult to know unless I saw your sheet and your goals. Can you please share a screenshot of what you are trying to do in 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.
Trying the first form based calendar. I have no "form" on the right I really wanted this to work. Please help
Hi Hilary, 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 50,000 Members who would love to help you with this. Thanks so much.
Is this working on Windows 64 bit and Office 365?
Regards
Peter from Sweden
Hi Peter this should work just fine, however if you do run into any issues just post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel so that our members can help you. Thanks very much.
Request help:
How can I use the in-cell-calendar for a range of cells in my spreadsheet? Thank you.
(ex: I need to input a series of dates in cells A20:M20.)
Hi yes you can Cecil, you can set the range to anything you like. Just use a hidden cell to save the range you have selected, and when a user selects a date in that calendar, add the date to whatever range the user has selected. For more details please post your entire requirements in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Thanks so much.
Thank you.
Hi Randy is there a way to do this on a mac ?
Hi and thanks, I believe so however there may be code updates required
You can check for the type of updates for a Mac here: www.macexcel.com/
I hope this helps and thanks so much.
Calendar one. How do I add it to multiple sheets in on workbook?
Hi and thanks you can just copy the sheet code from one sheet to another and adjust the range. I hope this helps and thanks .
Like the calendar a lot. Ran into an unexpected linking problem:
(Using Excel 2013 on native Windows 10 Toshiba laptop.)
After using the calendar awhile, I began getting a can't link error, although everything in my workbook worked. Tracked it down to a link between my workbook, and the downloaded workbooks used during install. The linking error happened because I moved those files, thinking they were not needed. But as it turned out, 3 Excel Calendars.xlsm is linked, and through it DatePicker.xlsm is linked. But...when I examine links in my workbook, or in the download workbook, the following is found: If I look at Inquire tab:Workbook Relationship, the diagram shows these links as existing. If I look at Data tab:Edit Links, no such links are shown in order to break them. (When I return the download workbooks to their original location, the error stops. Either way, everything works.) In my workbook, I have CalPopUp as Sheet3 (hidden) and Popup_Calendar Module, so I would think these are enough. Yes? This is important, as the finished workbook will reside on someone else's computer. --- Any suggestions? --- Thanks, Doug
Hi Doug, I do understand that issue. Sometimes when moving over the calendar the macros assigned don't always get written properly to the new calendar. The CalPopUp sheet contains a calendar as a backup, so this way if your calendar on your sheet gets deleted the backup is copied over (you could manually do this as well) (You just don't want two calendars on the same sheet)
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
Hi how do i get the download please
Hi Mike, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Good sharing👍👍
Thank you for your Likes, Shares & Comments. It really helps.
I wanted to create a calendar macro so I could put the date in whatever cell I select. My version of Excel, which is the latest, does not have the Microsoft Date Control. What can I do? Thanks!
Just download the workbook and follow the training in this video. You have 3 good options here for a Date Picker (download links in the description)
Hello! I have an error on calendar when I choose month. In Private Sub Build_Calendar() If i < CInt("01/" & Weekday((CB_Mth.Value) & "/" & (CB_Yr.Value))) Then the error is - Data type error
HI make sure that the values in your fields are numbers and that the field names are correct
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
@@ExcelForFreelancers Hello when I want to register to facebook group then message apperas This Page Isn't Available Right Now
@@ExcelForFreelancers HI make sure that the values in your fields are numbers and that the field names are correct. You think about your file 3_Excel_Calendars? I am not change these file. But error occur immediately when I click on E7 cell. Type mismatch runtime error 13.
Hi George if you have any issues joining the group please email the admin angeli@ExcelForFreelancers.com
I hope this helps and thanks so much.
Dear Randy, your video so cool. I want to implemen special Timer 'cutdown' into my excel file. But I faced with issues that Timer connected to cell. When user open the file and based on his name Timer 'cutdowm' must set time up ( 10 min) and start to work. Here is I found the issue: when user making modification in cell Timer is not working.....After to avoid this I try to create my own timer and set up time by formula....this solution works but new issue poped up: this kind of timer works only in one sheet due to textbox.controlsouce coneted only to one sheet to one cell. If i chose other sheet my Timer started but not counting time. Could you help me please, with Timer counting creation which will work in all worksheets and not freazze or stoped and when user activate each o cell for write some data or text into cell? Thank you in advance. Best regard. Best
Hi you would want to make sure to reference the full sheet in the control source and not just the cell (search google for Excel Control source sheet reference) 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
@@ExcelForFreelancers, ок. Thanks I will join
Cuando descargo la plantilla, en mi correo sale como si lo hubiera mandado pero no aparece nada
Hola y gracias. A veces esto puede aparecer en un teléfono, sin embargo, si recibe el correo electrónico en la computadora, no debe estar en blanco. Leí el correo electrónico que me enviaste y ese correo electrónico no estaba en blanco, así que descárgalo en tu computadora y debería funcionar bien.
Where can I download the calendarfrm user form?
Hi Colby, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Thanks
You are very welcome and I am happy to help Ali
Beautiful. Thanks for sharing
For sure, you are welcome
Can u also make a video on how to create a marquee text in excel without using Microsoft webbrowser as webbrowser doesn't work in Excel 2013 & 2015. I have tried but it doesn't smoothly animate the text because it is reflected after every second and I am not getting how to reflect in milliseconds for smooth animation.
Thank you for your suggestion. I will do my best
it errors out on CheckSheet. Error msg: "Compile error: Sub or Function not defined"
Hi Max, 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 30,000 Members who would love to help you with this. Thanks so much.
Excellent
Thank you very much, I appreciate it
Hello this in regards with the popup Calendar that's available for download. After downloaded the files "DATE PICKER SHAPE Based" in that the 27th date or the last row 4th Column doesn't work properly for eg: if we select 27 it shows next date that's 28. Why is it?? Can you please help with the solution for it?? Thank you
Hi sorry to hear about that it is not working correctly. I would like to take a look at that specific instance so i can see the issue. Perhaps you can join our Excel Facebook Group here: bit.ly/groupexcel , and post your workbook so me and other Excel members can fix the issue for you. Thanks so much.
Hello thank you for the reply. if its not much of the trouble the group that you mention is linked with facebook login isn't it? But unfortunately i don't use facebook. So, if its not much to ask can you provide the solution on this platform itself please. This is the link you had provided to one Kellie with this link (bit.ly/3_Cal_WbDl) which i also downloaded & found this problem, please if you help on this will be of great helps. Hope to hear from you asap. Thank you in advance.
Hi thanks for your comment. I would recommend using the Form Based Date picker as the shape based pick may have issues in certain workbooks. Thanks for your patience.
Hello is it possible to get the form based date picker link from where i could download it?? waiting for your reply. Thank you
Hi you already have it in the same workbook as the shape based (there are 3 calendars with the workbook in the above video, one is a form based)
Nice video 😊
Thank you so very much, I really appreciate that Saiful
Where is that download for those of us who started late to excel?
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
How to make the popup calendar close by pressing Esc button. Instead of using mouse to click on close button, is there any way to close the popup calendar close by pressing Esc button on keyboard. Thanks.
Its a good question. There are a few options. Please post the question in our group so we can get many different possible solutions. Http://bit.ly/groupexcel
Excel For Freelancers Posted the question in the group. Pls reply if you have any solution for it.
Excel For Freelancers Pls reply
Please be patient, as I have many requests and tasks as well as responsibilities and I have not been able to double check on the best solution for you just yet.
I had used the first one which is form calendar. But when i select a date and again visit the cell to change date, the form calendar is automatically switching to today's. Pls tell me how to stop the calendar from switching to today's month. Pls reply @Excel for freelancers
The Form Calendar (first One) will always have a small square around the current date however you are free to enter any date you want. The current date is not automatically entered into the cell date.
Excel For Freelancers I wants to know how to stop the calendar from switching to current month and year. When i enter a date in different month and year, the calendar should fix to that month and year if i again visit that cell.
Also if you go into the code for the calendar (double click the calendar) you see:
ThisDay = VBA.DateTime.Date
Change to:
ThisDay = Sheet1.Range("A1").Value
Make sure instead of A1, you use the cell that contains your date
Make sure you see my response above. This will solve your issue
Excel For Freelancers The above one has solved the issue. But i am getting am error whenever the linked cell is empty. If there is already a date in that cell then it is working fine, But if the cell is empty it is not working because the macro is not getting which month it should display. Pls tell how to fix that. If a date is entered the calendar must show according to that month and year but if the cell is empty the default should be set to today's date. Thanks in advance.
i got an error when i try to open the first calendar it saying "type mismatch" only the second calendar working plzzzz help me
Hi it's hard to tell what exactly is the cause however if you join our group and upload the file or screenshot for sure we can help you. Please join our Facebook group here: bit.ly/groupexcel
Thanks so much.
your video is very excellent. please give me vb cord & project file. plz plz
shafiqul islam Hi thanks for your message. You can download the complete workbook with code from here : www.excelforfreelancers.com/3-excel-calendars-download
thank you so much
For sure, you are very welcome
Nice
Thank you so very much, I really appreciate that Toha
I want to get this file I have tried 2 times but i have not got it
Hi very sorry to hear that you were unable to get it. Just click this link to download the ZIp file: bit.ly/3_Cal_WbDl
Type data mismatch in form pop-up
Hi Michal, 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 40,000 Members who would love to help you with this. Thanks so much.
Sir,
How could a pay for you to build a profile database for me?
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, I have created a Facebook group with 7000 Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
hi iwant calendar form
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
I'm using it for my Job.. and I want to use MS excel 2007..
2007 Should work for most of my applications. (I design everything in 2010). If you have a specific issue we can help in our Excel For Freelancers Facebook Group. (bit.ly/groupexcel )
How to do on Userform with datepicker
The First Option of the 3 options is a Userform Datepicker. Make sure you download your free copy with the links in the description.
I WANT LINK
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
You guys made a mistake, instead of having 3 excel calendars, the download for the forms and the tutorials. You have "Fade Out Messages" workbook and tutorials In both places 🤔. Can you fix this. I would like to learn how to do calendars in excel.😊
Hi thanks so much. Yes I did see some issue with that (before it was working but the mail service is making some changes) Anyways I will get it fixed right away, but you can download the workbook directly from this link: bit.ly/3_Cal_WbDl
I thinks one more disadvantage of second option should be mentioned.
Year Selection option is not available
Hi thanks, but a year option could easily be added. Thanks for your feedback.
How to make monday the first day of the week?
Hi Lars you can update the Weekday function inside the formulas on the hidden pop-up sheet I hope this helps and thanks.