Thank you so much - exactly what i needed to create an excel workbook with all employees to choose a date and see who is working on that particular date
Thanks so much Kobus, I am really happy you liked it. Make sure you check out tomorrow's video (6-18-2018) I have employee payroll that automatically is displayed in an html email so I think you would find it helpful.
Thank you for a really good feature. I've been searching for a solution like this since MS removed the date picker tool which used to be part of Additional Controls within the Userform options. Thanks!
I am glad you got it to work. There may still be a few kinks in the Calendar, but I think it's a nice option on some applications. I am glad you like it (I am thinking of making one that does a Date Range (to & From Dates) Like on those travel websites.
It was very simple and useful Randy. Can you please help me understand that at 5:00 what do you mean by adding and removing any protection. Appreciate it.
Hi Kunlj thanks very much for your comment and I am glad you like the training. I meant if you want to add sheet or workbook protection you can add it and update the sheet as you like. 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
thank you so much for making such great tutorials. I am learning a lot from your videos. I was looking for such date picker since long. its working great. One problem though, when we click any date of pop up calendar, it puts the date in cell M3, popup disappears and the cell selection is changed toward right cell N3. What if i want that selection downwards to cell M4 or M5.
Hi and thanks so much. You can update the selection change vba code to use for any cells you want. If you need help with this I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Randy, I really enjoy your videos. You have taught me so much. Thank you. I have a question about this date picker macro. Rather than just one cell, or a range of cells, will this work in a table of records where column A starts with a date?
Hi Johnny, thanks so much for your comment and glad you love the training. Yes, you can use this for an entire column by changing the range to something like Range("A:A") I hope this helps and thanks so much.
Thank you so much for this. Is there a way to use the calendar in combination with text boxes in a user form? In other words, when clicking within a text box the calendar appears and the date is filled in this text box when one is selected from the calendar. Appreciated.
Hi and thanks. Yes for sure its possible, and you would need the userform-based date picker. I show you how to do this in the updated version of this training for the members Here is the original training: ruclips.net/video/e7tUsgWh3Uw/видео.html Here is the members training in which I show you how to add the date picker: ruclips.net/video/8eEs6mT9oY8/видео.html I hope this helps and thanks so much.
Hi Randy. Same comments as the last video for here. Very generous of you to share these tools which are both useful and great for learning :)) Thumbs up!!
Great job, Randy. Works well. The only little bag I found are the months like 09/2018, that start on Fr or Sa. Then you cant see the 30. or 31. of the month.
Hi, I have made the update, Can you try to download the updated version from this link? bit.ly/FreeExcelUtilities Thanks for bringing that to my attention.
Great video, thank you. One question though, if we have several worksheets in a workbook which all have a date column, how we should apply this? Do we have to just insert one copy of the "Square Calendar Form" or one on each sheet? If only one is adequate, then where should we past the copy of the "Calendar " and whether or not we must refer to this object on each macro/sheet?
Hi Moe, thanks so much, You would want to copy and place a calendar on each sheet. It will stay hidden unless a user selects a date cell. I hope this helps and thanks so much.
Great gift - Thanks very much. I can suggest a small enhancement. Be able to set the year by typing it in. You may have to enter a Birthday that could be 1980 and its tedious to scroll back year by year till that year.
Hi and thanks so much Jeanne-Pierre. I do have an updated version in which you can select years using up or down arrows, which is helpful. Please watch the training coming this Tuesday, which will have that updated date picker. I hope this helps and thanks so much.
hi, thanks for this and Time picker. They work fantastic on separate sheets. Please can you let me know how to combine both in one sheet. Im trying to have TIME and DATE pickers in cells next to each.YOUR HELP IS MUCH APPRECIATED. thanks.
Thanks for sharing the file. Great tutor & example. I want just the Saturdays to be highlighted in color and other days to toned down in black any suggestions?
HI Thanks for your comment. You can color the individual shapes within the calendar so that they appear different than the other days. Each is a square shape in which the font and background can be colored differently. 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 with code screenshots here:bit.ly/groupexcel
Hello...It's an excellent calendar u have designed and thank you very much to share with us. It works nicely in single cell (where date is appeared) but its not work in merge cell . can you please advise. I badly need this solution . I'm your regular viewer. Looking forward for your help. Thanks a lot.
Hi and thanks, it will work just fine in a merged cell, just make sure that you do not have If Target.CountLarge > 1 then exit sub above. The "1" should be higher than the # of cells in a merged cell. I used this calendar in many merged cells. 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 I really like this vid, it works great thank you. What I need help with now is that I want to do the same thing again on my same worksheet but in a different column of cells and keep the other one I made. So I need two columns of cells with the date picker in them how can I do that. Can you help.
Hi thanks you can just update the range inside the code (as i explained in the video) . Once that range is updated, this calendar can work for any number of cells on a 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 with code screenshots here:bit.ly/groupexcel
Hi Randy, I like your pop-up calendar macro. Is there a way to either have it default to the current date or better yet, a place to click on in the lower left corner that will take you to the current date?
HI and thanks, within the code you can update it to check if the current cell selection is blank to set the date to the current date. This does require a good amount of VBA knowledge. I hope this helps and thanks so much.
HI and thanks you want to make sure both codes are within the same Selection Change event (You cannot have two Selection Change code on the same sheet. 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 30,000 Members who would love to help you with this. Thanks so much.
Hi, Thanks for this it is brilliant. I have one question on protection. When I protect the sheet the popup no longer works. It comes up with the error 'The Pop-up Calendar does not exist on this worksheet. Please copy the calendar over from another sheet and paste into this sheet' I have tried to copy the image to somewhere else on that sheet but this does not work either. Have a missed something or is it not possible to protect when using this? TIA
HI and thanks so much. Yes for sure it is possible, however when protecting a sheet make sure 'Edit Objects' is selected so that the shapes can be displayed and hidden, You may also want to add in xlUserInterfaceOnly into your protection so that VBA can make changes in which the user does not. You also must have a shape named 'Calendar' on the sheet you want to use it on. I hope this helps and thanks so much.
Randy, thank you very much for sharing this amazing calendar! I’ve followed your steps exactly and I get a msg box pop up saying 'The Pop-up Calendar doesn’t exist on this worksheet ...'. After that a calendar with missing last row gets inserted (sometimes a calendar with its parts apart get inserted) I also noticed that sub GroupCal doesn’t work could you please help to resolve the issue? however, it does exist and
Hi and thanks so much, make sure you delete all shapes on your sheet that are related to the calendar and copy and paste a new calendar inside the 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
@@ExcelForFreelancers when the macro created the sheet 'CallPopUp', for some reason the month names in range A8:A19 were the same and all of them read 'January'. I changed them to proper names and the calendar worked just fine! Appreciate your work, Randy, and thanks for the early reply!
Hi and thanks. I will do my best and add it to my list of videos to create. I have another date picker, even better, in mind for that so I will try. Thank you for your Likes, Shares & Comments. It really helps.
I've used this macro for a while and haven't had any issues, but with the year 2022, it won't calculate January 31st and will error out. Is there a way to fix this?
Hi Joshua, Thanks for your comment. You can double check the formulas on the hidden pop-up sheet and see what the problem is. You can also try downloading it again from the link below, as there have been updates along the way. I hope this helps and thanks so much. www.dropbox.com/s/llpqmfgv1xpm7v4/DatePicker.xlsm?dl=1
Excellent work. I have on my EcoExcel channel a new video of a calendar created with VBA programming. This creates the buttons at runtime, works with class modules. I would be honored to see the post.
First thank you. The date picker works just as describe and the instructions are easy to follow. My question is that I cannot get it to work on a sheet where my date falls into a cell/cells that are formatted into merged cells. Please help. Thank you in advance!
try this..... in your code, where you are referencing the merge cells......if A1:A2 are merged and this is where you want the date, instead of just A1, enter the full merge range, A1:A2.....
Hi thanks it is certainly possible, The code is open and you are free to customize it. However, this is not something I could answer within a RUclips comment. We have an amazing group of developers who could help you with this in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks very much.
HI this should have no problem on windows 10. 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 30,000 Members who would love to help you with this. Thanks so much.
Hi, I am unable to get the email for the file and i have tried two different emails at least 5 times, i have entered my email. Is it broken? What gives?
Hi 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 there, I got your emails, and the original email you replied to IS the download email that you got to download the file, so I am not sure what the misunderstanding was
Hi Paul, thanks for your comment. I have an updated Date picker from my latest application in which you can download from the description in the video here: ruclips.net/video/3K664ELswp4/видео.html I hope this helps and thanks so much.
i have data using table in my excel, how to make the calendar automatically (without editing cell range in macros code) applied in new cell when i added new rows in my existing table? please help
Hi and thank you can increase the range on your Selection Change code to include whatever range you want on the on sheet code, which will allow you to display the calendar on selection of any column or cells. 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
This doesn't seem to work for me. I wonder why. I followed the instructions very carefully, copied the worksheet code to my worksheet module, changed the cell reference as instructed, and copied the PopUp_Calendar module to my workbook, all done in the sequence given in the instructions. When I tried to use the Date Picker, VB returned the message "Run-time Error '9': Subscript out of range" and highlighted this line in the PopUp_Calendar module-"Set ws = ActiveWorkbook.Sheets("CalPopUp")" Where did I go wrong? Any help would be much appreciated. Thank you.
Hi and thanks for your comment. It is possible that you are using a non-English language pack that uses different names for sheets. Also its possible that you do not have a sheet called CalPopUp (check hidden sheets for that) 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
The Shape Pop-Up Calendar, (September17 and December17) shows only until the day 29th ... If change the year has the same problem in other months. How do I fix it?
Sir plz say me a solution for following code Sub Test() Dim template As Workbook Set template = Workbooks("D:\Users.xlsm") End Sub After run this code error pop-up subscript out of range
Hi please check your file path and all parameters. 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
6 лет назад+1
Hello Randy, Your date picker is really interesting. At first, it didn't work because it's in english (of course) and I work in french. After changing January for Janvier, everything went fine. On the other hand, I prefer calendars that go from Monday to Sunday. I went through all your code but didn't fine any clue on how to change that. Can you help me on this please? And also, I'd like to be able to change the name of the days to be in french so "Mo" would be "Lu", "Tu" would be "Ma", and so on. Would that be possible? Thank you very much.
Hi thanks very much. Using the Shape Based Calendar, you can un-hide the calendar sheet. This is where the original calendar is located. You can then edit those shapes to display what you like. Also on this sheet is a table that represents the dates. You can make changes in this table in order to change the starting days of he week. I hope this helps. If you have additional questions, please join our amazing Facebook group with thousands of Excel experts who can help you right here: bit.ly/groupexcel
6 лет назад
Thanks for your answer Randy. So, I've changed the names of the days. This is good. But now, I'm not sure how to change the starting day of the week. Here is the sheet "CalPopUp": 2018-05-22 1 2 3 4 5 2018 6 7 8 9 10 11 12 5 13 14 15 16 17 18 19 Mai 20 21 22 23 24 25 26 Mai 2018 27 28 29 30 31 0 $D$5 1 2 3 4 5 6 7 Janvier 8 9 10 11 12 13 14 Février 15 16 17 18 19 20 21 Mars 22 23 24 25 26 27 28 Avril 29 30 31 32 33 34 35 Mai 36 37 38 39 40 41 42 Juin Juillet Août Septembre Octobre Novembre Décembre 24 I think I have to change something in the first part where the figures go from 1 to 31 as I see that, for the month of May, the 1st is on Tuesday. Sunday and Monday are blank. If the week starts on Monday - as I want - then, I should have Monday blank and then, Tuesday would be 1, Wednesday would be 2 and so on. I understand that but don't know how to make the modification. Can you help again? Many thanks.
Yes sure, In the CalPopUp sheet look at cell B1, and you see this formula =IF(WEEKDAY(DATE(CalYear,MATCH($A$4,CalMonths,0),1))=1,DATE(CalYear,MATCH($A$4,CalMonths,0),1),"") For this day all you need to do is change the "=1" to "=2" then in C1, change the same part of the cell to "=3", and do this for all the days. On the last day of the week, change it to "=1" instead of "=7" So you are making changes from C1 to H1. That is all that you need to do to get it started on Monday instead of Sunday (Also please feel free to post in our group, I know you are already a member, then i can upload pictures as well. Thanks so much Helene
6 лет назад+1
I just love this "Date Picker", now with weeks starting on Mondays. Thanks again Randy.
Hi and thanks very much. You can simply update the cell formatting in which you plan to display the date. 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've tried multiple times now to download this workbook and I keep getting redirected to your web page where it asks me to submit my email and such. I've done so several times now as I certainly enjoy your work and teachings. Yet, I still can't get this work book to download. Thoughts / Help?
This will work just fine on a merged cell, just check your code above that you are not exiting the code with a possible exit such as If target.count > 1 then exit the exit sub. This type of code would prevent it from working on a merged cell
On your instructions for the date picker and the time picker it says if you have existing code that you want to keep, to place the code between "Selection Change" and "Deactivate Subs". Can you elaborate on exactly where that would be? I see "Private sub worksheet_deactivate ()" at the top. there is a line at the end of that set of text right after "End Sub", then after the line, the 1st line is "Private Sub Worksheet_Selection Change (ByVal Target as Range). I asked on the facebook page but no answer yet and I'm trying to get a timesheet created right now that has both a date picker and a time picker. Since there is text between both of the things you said to place it between, i'm not sure where exactly it would go. It would seem odd to place code for the time picker anywhere between all of that since all of that code is all for the Date Picker.
Hi Brandi, you would want to place that code in the Worksheet Code. You can access selection change via the upper right drop down list in the sheet VBA. (please make sure to download my sample to see how it has been done. I will also answer the same on the facebook post. I hope this helps
Hi, its a great addin... really appreciate for making it public....but for some reason I am getting a flick/lag for a second or two when I use the workbook.. like between the event of clicking on the cell and calendar pop up.. can you please advise?
Hi thanks for your comment. It depends on which calendar you are using and your machine. Perhaps you may need to disable events temporarily through the code, then re-enable the events. Perhaps we can help you in our Facebook Group so please join and post your detailed question with file or screen attachments here: bit.ly/groupexcel
HI thanks you can check the date format to make sure that is is returned in the proper format (Some workbooks use different formulas depending upon your country) 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 with code screenshots or upload your workbook so we can see the problem here:bit.ly/groupexcel
HI and thanks for your comment. Shape-based calendars cannot be used in userforms. You would want to use a userforms-based date picker within an existing userform. Shape-based date pickers are used within sheets. Thank you for your Likes, Shares & Comments. It really helps.
HI and thanks so much. The shape-based calendars cannot be used on a userform, so for userforms make sure you use userform-based date pickers. 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 Sara, thanks for your comment. You can copy the code by clicking Alt + F11 which will open the VBA Editor. You can then drag and drop the module and the code as well. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@@ExcelForFreelancers Hi, the formula is not working if I save the the spreadsheet as Excel Workbook. It is working with Excel Macro-Enable Workbook. Is there a way to make work the formula in Excel Workbook. Thank you!
Hi Sara, 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.
Hi Randy!!! Thanks a lot for this and many other great tutorials!!! There is just one issue: I already have Worksheer_SelectionChange sub in Sheet1, and no matter where on this sheet I try to paste your code it gives error “Ambiguous name detected”. Please help me with this
Hi Monica, you can only have one SelectionChange sub so that means you have to put it inside the existing (below or above) your existing selection change code. So take my code (Without the 'Selection Change' line and the "End Sub" line and paste that INSIDE your existing Selection change code (After the Selection change line" and BEFORE your existing code that you already have inside. 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 with code screenshots here:bit.ly/groupexcel
Hiiii, THANK YOU SO MUCH for giving this and time picker,... I had to create a tracker for my office to record if anyone gets any tasks to deligate anyone who's willing to can pick up looking into the file,.... It has to be mentioned with start date & time and deadline date & time,... WORKED GREAT when I was preparing the tracker and using it myself for testing,.... But the thing is when the file was shared,.. it threw an error it could not merge changes made by other's except any random one person,.... Could you please help where multiple ppl can pick eg: dates from cell F5:F100 (One cell each) while the file can save everyone's changes? please help
HI and thanks very much Venkat. I have a training on how to share and sync your macro-enabled workbook here: ruclips.net/video/aKV5seZmiBs/видео.html Thank you for your Likes, Shares & Comments. It really helps.
Hi Jay-ar thanks you can just change the Range to add multiple cells. I did this in the Employee Manager workbook. Feel free to view the Employee Manager Series and download the workbook from here: bit.ly/EmplMgr20_WbDl On the Employee Manager sheet (in the code) i have added multiple cells in which the date pop-up will appear. 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
Can someone help me with this error please? I have copied the Calendar object in two worksheets and copied and pasted the code to both of these sheets and corrected the cell/column range for each one. This error doesn't seem to have anything to do with these sheets but is from the module itself. The error is noted below right after the corresponding line: 'Create Calendar Sheet on First Run of Calendar Sub CreateCalSht() Dim ColCnt, RowCnt, DayCnt, CalCol As Long Dim ws, ActSht As Worksheet Set ActSht = ActiveSheet 'On Error GoTo NoCal ActiveSheet.Shapes("Calendar").Copy Set ws = ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)) RUN -TIME ERROR 1004 ( Method "Add" of object" sheets" failed) ws.Name = "CalPopUp" ActSht.Activate Thank you
Hi Moe, 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 James, yes for sure just change the selection_Change code to contain multiple cells. There is no limit to the # of cells that you can use this calendar in a cell.
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 40,000 Members who would love to help you with this. Thanks so much.
How to using this date picker to vba project (user form) and the result of the date can auto fill to the text box.. Because excel 64bit is missing date picker...😔😔
Hi Over if you are using a userform, you will want to use a Date Picker that allows for 64 bit systems. If you are using a cell in a sheet, then you can use a Shape-based pop-up (Like the one in this video) or a form-based pop-up. I go over 3 different date picker styles in this video: ruclips.net/video/PLAJ08LP7kE/видео.html
Hi after getting this type of error, Reset your code, then in the VBA Editor go to Tools, References, and look for something that shows "MISSING", then you will have to locate the missing library and replace it. Then it will work properly. If you have further questions I have created a Facebook group with 5000 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 thanks you may just have to format the date. If the date is in a cell you can give it a date format. IF you want to format it in VBA you can do something like this Sheet1.Range("A1").value = Format(Sheet1.Range("A1").value,"dd/mm/yyyy"). 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 with code screenshots here:bit.ly/groupexcel
Hi that just means you are missing the calendar on the sheet. You can copy it from the source workbook into your sheet to make sure you have the calendar.
hi, i am unable to paste calendar properly, it is showing dates as 1,1,1, in the calendar but it is still working fine when i select date i am getting correct date. But how can i make it display properly.
Hi thanks so much and glad you got it. I know its a bit tricky as you have to copy over the module and the calendar, along with the code on the worksheet. I am glad you got it working.
Hi thanks for the great question. There are two good ways you can get the shape calendar to work with protection. The first is to protect the sheets with Edit Shapes selected this should allow it to work (Because in the code the calendar is grouped and ungroped many times. The 2nd way is to add Sheet1.Unprotect before any ungrouping and Sheet1. Protect after any grouping inside the macros . (just use the correct sheet # and any password) This way the unprotecting and protecting of the sheet is done inside the macros (Please make sure the sheet is unprotected when you first paste in the calendar the first time. I hope this helps
Sure no problem, I am here to help. You can test it out. Just remember if you Unprotect and Protect make sure you do both for each macro (any macro that uses Group or Ungroup
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Dude, you do some amazing work, I have used so much of your stuff, and followed so many tutorials. You are a true God among Excel users!
Thank you so very much, I really appreciate that. You will love the new POS with Inventory here: ruclips.net/video/SbjBgqzbA3w/видео.html
Thank you so much - exactly what i needed to create an excel workbook with all employees to choose a date and see who is working on that particular date
Thanks so much Kobus, I am really happy you liked it. Make sure you check out tomorrow's video (6-18-2018) I have employee payroll that automatically is displayed in an html email so I think you would find it helpful.
I was looking for this, Thank you so much, Mr.Randy, You are the master of Excel for sure
Glad it was helpful! Thank you very much Raghad
Thank you for a really good feature. I've been searching for a solution like this since MS removed the date picker tool which used to be part of Additional Controls within the Userform options. Thanks!
James Lloyd, Thanks so much. Glad you liked it. The shaped base date picker is the nicest but also least stable. I like them all for different reasons
Randy worked great, on my laptop I had to resize the sharp to display all the days. Thanks for sharing it.
I am glad you got it to work. There may still be a few kinks in the Calendar, but I think it's a nice option on some applications. I am glad you like it (I am thinking of making one that does a Date Range (to & From Dates) Like on those travel websites.
@@ExcelForFreelancers Sounds good Randy, I meant shape not sharp darn auto spell correct lol. Thanks again
@@charliedeutsch8392 No worries I knew what you mean. I always appreciate your feedback and comments Charlie
It was very simple and useful Randy. Can you please help me understand that at 5:00 what do you mean by adding and removing any protection. Appreciate it.
Hi Kunlj thanks very much for your comment and I am glad you like the training. I meant if you want to add sheet or workbook protection you can add it and update the sheet as you like.
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
thank you so much for making such great tutorials. I am learning a lot from your videos. I was looking for such date picker since long. its working great. One problem though, when we click any date of pop up calendar, it puts the date in cell M3, popup disappears and the cell selection is changed toward right cell N3. What if i want that selection downwards to cell M4 or M5.
Hi and thanks so much. You can update the selection change vba code to use for any cells you want.
If you need help with this I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Randy, I really enjoy your videos. You have taught me so much. Thank you.
I have a question about this date picker macro. Rather than just one cell, or a range of cells, will this work in a table of records where column A starts with a date?
Hi Johnny, thanks so much for your comment and glad you love the training. Yes, you can use this for an entire column by changing the range to something like Range("A:A")
I hope this helps and thanks so much.
Great solutions!!! Many Thanks!!!!
For sure, you are very welcome
Thank you so much for this. Is there a way to use the calendar in combination with text boxes in a user form? In other words, when clicking within a text box the calendar appears and the date is filled in this text box when one is selected from the calendar. Appreciated.
Hi and thanks. Yes for sure its possible, and you would need the userform-based date picker. I show you how to do this in the updated version of this training for the members
Here is the original training: ruclips.net/video/e7tUsgWh3Uw/видео.html
Here is the members training in which I show you how to add the date picker: ruclips.net/video/8eEs6mT9oY8/видео.html
I hope this helps and thanks so much.
Thank you so much!@@ExcelForFreelancers
Hi Randy. Same comments as the last video for here. Very generous of you to share these tools which are both useful and great for learning :)) Thumbs up!!
Thank you Wayne, make sure you download this free data picker using the links in the description.
@@ExcelForFreelancers Got it.. done.. thanks!!
Great job, Randy. Works well. The only little bag I found are the months like 09/2018, that start on Fr or Sa. Then you cant see the 30. or 31. of the month.
Hi thanks so much. I will make the updates. Glad you like it.
Hi, I have made the update, Can you try to download the updated version from this link? bit.ly/FreeExcelUtilities
Thanks for bringing that to my attention.
@@ExcelForFreelancers Hi! Thank you for this. I noticed that second day in week 6 doesn't show up. Example 31.12.2018 and 31.08.2020.are missing.
Great video, thank you. One question though, if we have several worksheets in a workbook which all have a date column, how we should apply this? Do we have to just insert one copy of the "Square Calendar Form" or one on each sheet? If only one is adequate, then where should we past the copy of the "Calendar " and whether or not we must refer to this object on each macro/sheet?
Hi Moe, thanks so much, You would want to copy and place a calendar on each sheet. It will stay hidden unless a user selects a date cell. I hope this helps and thanks so much.
Perfect! Just what I was looking for.. thank you and well done :)
For sure, you are very welcome Rahath
Great gift - Thanks very much. I can suggest a small enhancement. Be able to set the year by typing it in. You may have to enter a Birthday that could be 1980 and its tedious to scroll back year by year till that year.
Hi and thanks so much Jeanne-Pierre. I do have an updated version in which you can select years using up or down arrows, which is helpful. Please watch the training coming this Tuesday, which will have that updated date picker. I hope this helps and thanks so much.
hi, thanks for this and Time picker. They work fantastic on separate sheets. Please can you let me know how to combine both in one sheet. Im trying to have TIME and DATE pickers in cells next to each.YOUR HELP IS MUCH APPRECIATED. thanks.
Hi thanks so much. I did answer this question in our group from you, so please check there. Much appreciated.
@@ExcelForFreelancers SAME PROBLEM..HOW CAN USE BOTH CODE IN ONE SHEET BECAUSE DATE AND TIME PICKER ON SAME SHEET..WHERE I CAN FIND THE ANSWER? PLEASE
Thanks for sharing the file. Great tutor & example. I want just the Saturdays to be highlighted in color and other days to toned down in black any suggestions?
HI Thanks for your comment. You can color the individual shapes within the calendar so that they appear different than the other days. Each is a square shape in which the font and background can be colored differently. 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 with code screenshots here:bit.ly/groupexcel
Hello...It's an excellent calendar u have designed and thank you very much to share with us. It works nicely in single cell (where date is appeared) but its not work in merge cell . can you please advise. I badly need this solution . I'm your regular viewer. Looking forward for your help. Thanks a lot.
Hi and thanks, it will work just fine in a merged cell, just make sure that you do not have If Target.CountLarge > 1 then exit sub above. The "1" should be higher than the # of cells in a merged cell. I used this calendar in many merged cells. 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 I really like this vid, it works great thank you. What I need help with now is that I want to do the same thing again on my same worksheet but in a different column of cells and keep the other one I made. So I need two columns of cells with the date picker in them how can I do that. Can you help.
Hi thanks you can just update the range inside the code (as i explained in the video) . Once that range is updated, this calendar can work for any number of cells on a 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 with code screenshots here:bit.ly/groupexcel
Hi Randy, I like your pop-up calendar macro.
Is there a way to either have it default to the current date or better yet, a place to click on in the lower left corner that will take you to the current date?
HI and thanks, within the code you can update it to check if the current cell selection is blank to set the date to the current date. This does require a good amount of VBA knowledge. I hope this helps and thanks so much.
Thank you very much
For sure, you are very welcome, I am glad I could help.
Is this capable of working within a table (listObject) where you might add or delete rows? If not, Is there an alternative that will work?
Hi Scott this Date picker can work with any table as well, even when rows are added and deleted. I hope this helps and thanks so much.
Randy, I would love to have a way to add this functionality to a user form in VBA. Is this possible, and how?
Hi and thanks very much. I have that in this video here ruclips.net/video/PLAJ08LP7kE/видео.html
I hope this helps and thanks so much.
How i can import both time and date pop up picker in same sheet? i tried but it's not working
HI and thanks you want to make sure both codes are within the same Selection Change event (You cannot have two Selection Change code on the same sheet.
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 30,000 Members who would love to help you with this. Thanks so much.
Hi, Thanks for this it is brilliant. I have one question on protection. When I protect the sheet the popup no longer works. It comes up with the error 'The Pop-up Calendar does not exist on this worksheet. Please copy the calendar over from another sheet and paste into this sheet' I have tried to copy the image to somewhere else on that sheet but this does not work either. Have a missed something or is it not possible to protect when using this? TIA
HI and thanks so much. Yes for sure it is possible, however when protecting a sheet make sure 'Edit Objects' is selected so that the shapes can be displayed and hidden, You may also want to add in xlUserInterfaceOnly into your protection so that VBA can make changes in which the user does not. You also must have a shape named 'Calendar' on the sheet you want to use it on.
I hope this helps and thanks so much.
Do you have any video for stock control with Microsoft Access?
HI and thanks. I do not as I just focus on Excel.
Thank you so much for replay. Date picker working but date 31 not working. Do you have any solve for 31.
Hi and yes you can update the formula in the sheet-based calendar which will fix the formula in columns A through H. I hope this helps and thanks.
Nice video 😌
Thank you so very much, I really appreciate that Saiful
thanks
For sure, you are very welcome Pappu.
Randy, thank you very much for sharing this amazing calendar!
I’ve followed your steps exactly and I get a msg box pop up saying 'The Pop-up Calendar doesn’t exist on this worksheet ...'. After that a calendar with missing last row gets inserted (sometimes a calendar with its parts apart get inserted)
I also noticed that sub GroupCal doesn’t work
could you please help to resolve the issue?
however, it does exist and
Hi and thanks so much, make sure you delete all shapes on your sheet that are related to the calendar and copy and paste a new calendar inside the 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
@@ExcelForFreelancers
when the macro created the sheet 'CallPopUp', for some reason the month names in range A8:A19 were the same and all of them read 'January'. I changed them to proper names and the calendar worked just fine!
Appreciate your work, Randy, and thanks for the early reply!
For sure, you are very welcome> I am glad you were able to get it worked out. It is a really nice Calendar but sometimes a bit tricky.
Can you teach us to build one from scratch?
Hi and thanks. I will do my best and add it to my list of videos to create. I have another date picker, even better, in mind for that so I will try. Thank you for your Likes, Shares & Comments. It really helps.
I've used this macro for a while and haven't had any issues, but with the year 2022, it won't calculate January 31st and will error out. Is there a way to fix this?
Hi Joshua,
Thanks for your comment. You can double check the formulas on the hidden pop-up sheet and see what the problem is. You can also try downloading it again from the link below, as there have been updates along the way. I hope this helps and thanks so much.
www.dropbox.com/s/llpqmfgv1xpm7v4/DatePicker.xlsm?dl=1
Excellent work. I have on my EcoExcel channel a new video of a calendar created with VBA programming.
This creates the buttons at runtime, works with class modules. I would be honored to see the post.
Thanks very much. I will have a look at your calendar. Sounds very interesting. Much appreciated.
First thank you. The date picker works just as describe and the instructions are easy to follow. My question is that I cannot get it to work on a sheet where my date falls into a cell/cells that are formatted into merged cells. Please help.
Thank you in advance!
I would use "Center Across Selection' instead of merged cells. This will ensure that you do not have the calendar works well.
try this.....
in your code, where you are referencing the merge cells......if A1:A2 are merged and this is where you want the date, instead of just A1, enter the full merge range, A1:A2.....
Thanks so much Don :)
Glad to help Jesus
Hi, how can we modify this to get week numbers and monday would be first day of the week?
Hi thanks it is certainly possible, The code is open and you are free to customize it. However, this is not something I could answer within a RUclips comment. We have an amazing group of developers who could help you with this in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Thanks very much.
My windows 10. Before Date picker working right now not working date picker. What problem please give idea.
HI this should have no problem on windows 10. 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 30,000 Members who would love to help you with this. Thanks so much.
Hi, I am unable to get the email for the file and i have tried two different emails at least 5 times, i have entered my email. Is it broken? What gives?
Hi 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 there, I got your emails, and the original email you replied to IS the download email that you got to download the file, so I am not sure what the misunderstanding was
Very nice sir
Thanks very much. :)
I had used this and have picked it up again but the date is still reverting back to december 2018. How can it be changed to default to todays date?
Hi Paul, thanks for your comment. I have an updated Date picker from my latest application in which you can download from the description in the video here: ruclips.net/video/3K664ELswp4/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Is it possible for me to just alter the old code so that it stops displaying 2018 and display this year instead?
Yes sure you can unhide the hidden sheet called CalPop-up and just update the year inside that sheet. I hope this helps and thanks so much.
i have data using table in my excel, how to make the calendar automatically (without editing cell range in macros code) applied in new cell when i added new rows in my existing table? please help
Hi and thank you can increase the range on your Selection Change code to include whatever range you want on the on sheet code, which will allow you to display the calendar on selection of any column or cells. 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
This doesn't seem to work for me. I wonder why. I followed the instructions very carefully, copied the worksheet code to my worksheet module, changed the cell reference as instructed, and copied the PopUp_Calendar module to my workbook, all done in the sequence given in the instructions. When I tried to use the Date Picker, VB returned the message "Run-time Error '9': Subscript out of range" and highlighted this line in the PopUp_Calendar module-"Set ws = ActiveWorkbook.Sheets("CalPopUp")"
Where did I go wrong? Any help would be much appreciated. Thank you.
Hi and thanks for your comment. It is possible that you are using a non-English language pack that uses different names for sheets. Also its possible that you do not have a sheet called CalPopUp (check hidden sheets for that)
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
Interesting
Thanks so much Joe. Thank you for your Likes, Shares & Comments. It really helps.
Hey there. awesome videos. Is there a way for this to be done in a user form?
HI yes there are many great Userform Date Pickers. In this video & download I go over a userform as well: ruclips.net/video/PLAJ08LP7kE/видео.html
Excel For Freelancers thank you so much! Worked like a gem!
Great, happy to hear that
The Shape Pop-Up Calendar, (September17 and December17) shows only until the day 29th ... If change the year has the same problem in other months. How do I fix it?
HI Newton, this was an old issue that is fixed already. Feel free to download the new version here; bit.ly/FreeExcelUtilities
Can you upload a complete video on school management system ?
Hi thanks very much. That would be a paid course since its a large project. I will add it to my list. Very nice idea
superb
Thank you very much Tony
Sir plz say me a solution for following code
Sub Test()
Dim template As Workbook
Set template = Workbooks("D:\Users.xlsm")
End Sub
After run this code error pop-up subscript out of range
Hi please check your file path and all parameters. 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 Randy,
Your date picker is really interesting. At first, it didn't work because it's in english (of course) and I work in french. After changing January for Janvier, everything went fine.
On the other hand, I prefer calendars that go from Monday to Sunday. I went through all your code but didn't fine any clue on how to change that. Can you help me on this please? And also, I'd like to be able to change the name of the days to be in french so "Mo" would be "Lu", "Tu" would be "Ma", and so on. Would that be possible?
Thank you very much.
Hi thanks very much. Using the Shape Based Calendar, you can un-hide the calendar sheet. This is where the original calendar is located. You can then edit those shapes to display what you like. Also on this sheet is a table that represents the dates. You can make changes in this table in order to change the starting days of he week. I hope this helps. If you have additional questions, please join our amazing Facebook group with thousands of Excel experts who can help you right here: bit.ly/groupexcel
Thanks for your answer Randy. So, I've changed the names of the days. This is good. But now, I'm not sure how to change the starting day of the week. Here is the sheet "CalPopUp":
2018-05-22 1 2 3 4 5
2018 6 7 8 9 10 11 12
5 13 14 15 16 17 18 19
Mai 20 21 22 23 24 25 26
Mai 2018 27 28 29 30 31
0
$D$5 1 2 3 4 5 6 7
Janvier 8 9 10 11 12 13 14
Février 15 16 17 18 19 20 21
Mars 22 23 24 25 26 27 28
Avril 29 30 31 32 33 34 35
Mai 36 37 38 39 40 41 42
Juin
Juillet
Août
Septembre
Octobre
Novembre
Décembre
24
I think I have to change something in the first part where the figures go from 1 to 31 as I see that, for the month of May, the 1st is on Tuesday. Sunday and Monday are blank. If the week starts on Monday - as I want - then, I should have Monday blank and then, Tuesday would be 1, Wednesday would be 2 and so on. I understand that but don't know how to make the modification.
Can you help again? Many thanks.
Yes sure, In the CalPopUp sheet look at cell B1, and you see this formula
=IF(WEEKDAY(DATE(CalYear,MATCH($A$4,CalMonths,0),1))=1,DATE(CalYear,MATCH($A$4,CalMonths,0),1),"")
For this day all you need to do is change the "=1" to "=2"
then in C1, change the same part of the cell to "=3", and do this for all the days. On the last day of the week, change it to "=1" instead of "=7"
So you are making changes from C1 to H1. That is all that you need to do to get it started on Monday instead of Sunday
(Also please feel free to post in our group, I know you are already a member, then i can upload pictures as well. Thanks so much Helene
I just love this "Date Picker", now with weeks starting on Mondays. Thanks again Randy.
For sure, you are very welcome :)
Hii how to change date split character (/) to (-) and date format dd-mm-yyyy in this code
Hi and thanks very much. You can simply update the cell formatting in which you plan to display the date. 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've tried multiple times now to download this workbook and I keep getting redirected to your web page where it asks me to submit my email and such. I've done so several times now as I certainly enjoy your work and teachings. Yet, I still can't get this work book to download.
Thoughts / Help?
Hi Richard, so sorry about that. It may have gone to Spam, You can download the date picker from this link here: bit.ly/FreeExcelUtilities
I cant use it on a merge cell,
How can I use on a merge cells? Thanks in advance
This will work just fine on a merged cell, just check your code above that you are not exiting the code with a possible exit such as
If target.count > 1 then exit the exit sub.
This type of code would prevent it from working on a merged cell
On your instructions for the date picker and the time picker it says if you have existing code that you want to keep, to place the code between "Selection Change" and "Deactivate Subs". Can you elaborate on exactly where that would be? I see "Private sub worksheet_deactivate ()" at the top. there is a line at the end of that set of text right after "End Sub", then after the line, the 1st line is "Private Sub Worksheet_Selection Change (ByVal Target as Range). I asked on the facebook page but no answer yet and I'm trying to get a timesheet created right now that has both a date picker and a time picker. Since there is text between both of the things you said to place it between, i'm not sure where exactly it would go. It would seem odd to place code for the time picker anywhere between all of that since all of that code is all for the Date Picker.
Hi Brandi, you would want to place that code in the Worksheet Code. You can access selection change via the upper right drop down list in the sheet VBA. (please make sure to download my sample to see how it has been done. I will also answer the same on the facebook post. I hope this helps
Hi, its a great addin... really appreciate for making it public....but for some reason I am getting a flick/lag for a second or two when I use the workbook.. like between the event of clicking on the cell and calendar pop up.. can you please advise?
Hi thanks for your comment. It depends on which calendar you are using and your machine. Perhaps you may need to disable events temporarily through the code, then re-enable the events. Perhaps we can help you in our Facebook Group so please join and post your detailed question with file or screen attachments here: bit.ly/groupexcel
Sir I have set your date picker in my excel but If I click on date cell, workbook tremble please give me a solution
HI thanks you can check the date format to make sure that is is returned in the proper format (Some workbooks use different formulas depending upon your country) 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 with code screenshots or upload your workbook so we can see the problem here:bit.ly/groupexcel
how should i use it in the userform ?
HI and thanks for your comment. Shape-based calendars cannot be used in userforms. You would want to use a userforms-based date picker within an existing userform. Shape-based date pickers are used within sheets. Thank you for your Likes, Shares & Comments. It really helps.
Sir how can I make my cALENDAR & attach on my user form
HI and thanks so much. The shape-based calendars cannot be used on a userform, so for userforms make sure you use userform-based date pickers. 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, where to find the text for date picker to copy in my worksheet? Thank you
Hi Sara, thanks for your comment. You can copy the code by clicking Alt + F11 which will open the VBA Editor. You can then drag and drop the module and the code as well.
I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@@ExcelForFreelancers Hi, the formula is not working if I save the the spreadsheet as Excel Workbook. It is working with Excel Macro-Enable Workbook. Is there a way to make work the formula in Excel Workbook. Thank you!
Hi Sara, 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.
Hi Randy!!! Thanks a lot for this and many other great tutorials!!! There is just one issue: I already have Worksheer_SelectionChange sub in Sheet1, and no matter where on this sheet I try to paste your code it gives error “Ambiguous name detected”. Please help me with this
Hi Monica, you can only have one SelectionChange sub so that means you have to put it inside the existing (below or above) your existing selection change code. So take my code (Without the 'Selection Change' line and the "End Sub" line and paste that INSIDE your existing Selection change code (After the Selection change line" and BEFORE your existing code that you already have inside.
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 with code screenshots here:bit.ly/groupexcel
Excel For Freelancers Thank you!!! That helped!
Hiiii, THANK YOU SO MUCH for giving this and time picker,... I had to create a tracker for my office to record if anyone gets any tasks to deligate anyone who's willing to can pick up looking into the file,.... It has to be mentioned with start date & time and deadline date & time,... WORKED GREAT when I was preparing the tracker and using it myself for testing,.... But the thing is when the file was shared,.. it threw an error it could not merge changes made by other's except any random one person,.... Could you please help where multiple ppl can pick eg: dates from cell F5:F100 (One cell each) while the file can save everyone's changes? please help
HI and thanks very much Venkat. I have a training on how to share and sync your macro-enabled workbook here: ruclips.net/video/aKV5seZmiBs/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers wow great,... Will check it out thank you so much
how can i add the date in multiple cell.....Please help me in this
Hi Jay-ar thanks you can just change the Range to add multiple cells. I did this in the Employee Manager workbook. Feel free to view the Employee Manager Series and download the workbook from here: bit.ly/EmplMgr20_WbDl
On the Employee Manager sheet (in the code) i have added multiple cells in which the date pop-up will appear.
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
Can someone help me with this error please?
I have copied the Calendar object in two worksheets and copied and pasted the code to both of these sheets and corrected the cell/column range for each one. This error doesn't seem to have anything to do with these sheets but is from the module itself.
The error is noted below right after the corresponding line:
'Create Calendar Sheet on First Run of Calendar
Sub CreateCalSht()
Dim ColCnt, RowCnt, DayCnt, CalCol As Long
Dim ws, ActSht As Worksheet
Set ActSht = ActiveSheet
'On Error GoTo NoCal
ActiveSheet.Shapes("Calendar").Copy
Set ws = ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
RUN -TIME ERROR 1004 ( Method "Add" of object" sheets" failed)
ws.Name = "CalPopUp"
ActSht.Activate
Thank you
Hi Moe, 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.
Can you have this several times on one sheet
Hi James, yes for sure just change the selection_Change code to contain multiple cells. There is no limit to the # of cells that you can use this calendar in a cell.
hello, in some case.. the name of month and year going to #NAME.. whats happened? can help me to fix it?
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 40,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers waiting for group approval
How to using this date picker to vba project (user form) and the result of the date can auto fill to the text box..
Because excel 64bit is missing date picker...😔😔
I want to call date picker and show the pop up when text box are clicked..
Hi Over if you are using a userform, you will want to use a Date Picker that allows for 64 bit systems. If you are using a cell in a sheet, then you can use a Shape-based pop-up (Like the one in this video) or a form-based pop-up. I go over 3 different date picker styles in this video: ruclips.net/video/PLAJ08LP7kE/видео.html
@@ExcelForFreelancers oke thanks you dude..
Hi ..
im getting an error as
compile error
cannot find project or library
kindly help
Hi after getting this type of error, Reset your code, then in the VBA Editor go to Tools, References, and look for something that shows "MISSING", then you will have to locate the missing library and replace it. Then it will work properly. If you have further questions I have created a Facebook group with 5000 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.
Works well, but I get Excel's date Number, not the date.... how do I change that?
HI thanks you may just have to format the date. If the date is in a cell you can give it a date format. IF you want to format it in VBA you can do something like this Sheet1.Range("A1").value = Format(Sheet1.Range("A1").value,"dd/mm/yyyy").
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 with code screenshots here:bit.ly/groupexcel
There is error in ActiveSheet.Shapes("Calendar").Copy
How do I solve that. Thanks
Hi that just means you are missing the calendar on the sheet. You can copy it from the source workbook into your sheet to make sure you have the calendar.
@@ExcelForFreelancers should we download a calendar add-ins or something?
How to make monday first day of the week?
Hi and thanks very much, you can go into the hidden popup calendar sheet and adjust the weekday formula.
I hope this helps and thanks so much.
i wait for many hours (not a few minutes) for the email. thanks btw
Hi sorry you did not receive the email. You can download your free date picker from this link here: bit.ly/FreeExcelUtilities
hi, i am unable to paste calendar properly, it is showing dates as 1,1,1, in the calendar but it is still working fine when i select date i am getting correct date. But how can i make it display properly.
i am sorry got it now, thanks for great Macro
Hi thanks so much and glad you got it. I know its a bit tricky as you have to copy over the module and the calendar, along with the code on the worksheet. I am glad you got it working.
Sir, why the dtpicker not work if the sheet in protect mode, thanks much...
Hi thanks for the great question. There are two good ways you can get the shape calendar to work with protection. The first is to protect the sheets with Edit Shapes selected this should allow it to work (Because in the code the calendar is grouped and ungroped many times.
The 2nd way is to add Sheet1.Unprotect before any ungrouping and Sheet1. Protect after any grouping inside the macros . (just use the correct sheet # and any password) This way the unprotecting and protecting of the sheet is done inside the macros (Please make sure the sheet is unprotected when you first paste in the calendar the first time.
I hope this helps
Excel For Freelancers thanks for great response, hi appreciate to you all.
Let me try your suggestions. Very big Thanks before....
Sure no problem, I am here to help. You can test it out. Just remember if you Unprotect and Protect make sure you do both for each macro (any macro that uses Group or Ungroup
it's work, Amazing. Thank you.
Excellent. So glad to hear that. :)
Hi, Why it have a password?
HI, No password. It should be open and unlocked. (You may want to add your own password in the future)