🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

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!

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

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.

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!

@ExcelForFreelancers

3 жыл бұрын

Thank you so very much, I really appreciate that. You will love the new POS with Inventory here: kzread.info/dash/bejne/hZaepMmqqsWnY9o.html

Perfect! Just what I was looking for.. thank you and well done :)

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome Rahath

I was looking for this, Thank you so much, Mr.Randy, You are the master of Excel for sure

@ExcelForFreelancers

2 жыл бұрын

Glad it was helpful! Thank you very much Raghad

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!!

@ExcelForFreelancers

3 жыл бұрын

Thank you Wayne, make sure you download this free data picker using the links in the description.

@wayneedmondson1065

3 жыл бұрын

@@ExcelForFreelancers Got it.. done.. thanks!!

Randy worked great, on my laptop I had to resize the sharp to display all the days. Thanks for sharing it.

@ExcelForFreelancers

5 жыл бұрын

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.

@charliedeutsch8392

5 жыл бұрын

@@ExcelForFreelancers Sounds good Randy, I meant shape not sharp darn auto spell correct lol. Thanks again

@ExcelForFreelancers

5 жыл бұрын

@@charliedeutsch8392 No worries I knew what you mean. I always appreciate your feedback and comments Charlie

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?

@ExcelForFreelancers

2 жыл бұрын

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.

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?

@ExcelForFreelancers

6 жыл бұрын

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

Great solutions!!! Many Thanks!!!!

@ExcelForFreelancers

3 жыл бұрын

For sure, you are very welcome

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.

@ExcelForFreelancers

6 жыл бұрын

Hi thanks so much. I will make the updates. Glad you like it.

@ExcelForFreelancers

6 жыл бұрын

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.

@catalinlazar4175

5 жыл бұрын

@@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.

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?

@ExcelForFreelancers

3 жыл бұрын

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.

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?

@ExcelForFreelancers

2 жыл бұрын

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.

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.

@ExcelForFreelancers

6 жыл бұрын

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

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.

@ExcelForFreelancers

2 жыл бұрын

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/

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.

@ExcelForFreelancers

4 жыл бұрын

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 very much

@ExcelForFreelancers

3 жыл бұрын

For sure, you are very welcome, I am glad I could help.

Very nice sir

@ExcelForFreelancers

6 жыл бұрын

Thanks very much. :)

Nice video 😌

@ExcelForFreelancers

2 жыл бұрын

Thank you so very much, I really appreciate that Saiful

superb

@ExcelForFreelancers

5 жыл бұрын

Thank you very much Tony

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

@ExcelForFreelancers

5 ай бұрын

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.

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?

@ExcelForFreelancers

6 жыл бұрын

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

thanks

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome Pappu.

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.

@ExcelForFreelancers

4 жыл бұрын

Hi thanks so much. I did answer this question in our group from you, so please check there. Much appreciated.

@imranashraf2530

4 жыл бұрын

@@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

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.

@ExcelForFreelancers

2 жыл бұрын

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.

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?

@ExcelForFreelancers

3 жыл бұрын

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.

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.

@ExcelForFreelancers

7 ай бұрын

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: kzread.info/dash/bejne/l2uot9Wgh8uZhdo.html Here is the members training in which I show you how to add the date picker: kzread.info/dash/bejne/apl51ZimhJzViZs.html I hope this helps and thanks so much.

@TDG995

7 ай бұрын

Thank you so much!@@ExcelForFreelancers

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

@ExcelForFreelancers

3 жыл бұрын

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

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.

@ExcelForFreelancers

5 жыл бұрын

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

Randy, I would love to have a way to add this functionality to a user form in VBA. Is this possible, and how?

@ExcelForFreelancers

Жыл бұрын

Hi and thanks very much. I have that in this video here kzread.info/dash/bejne/goB1rJJxfLOdm6g.html I hope this helps and thanks so much.

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.

@ExcelForFreelancers

3 жыл бұрын

Thanks very much. I will have a look at your calendar. Sounds very interesting. Much appreciated.

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?

@ExcelForFreelancers

5 жыл бұрын

HI Newton, this was an old issue that is fixed already. Feel free to download the new version here; bit.ly/FreeExcelUtilities

Hi, how can we modify this to get week numbers and monday would be first day of the week?

@ExcelForFreelancers

5 жыл бұрын

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 KZread 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.

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?

@ExcelForFreelancers

5 жыл бұрын

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

Do you have any video for stock control with Microsoft Access?

@ExcelForFreelancers

3 жыл бұрын

HI and thanks. I do not as I just focus on Excel.

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.

@ExcelForFreelancers

2 жыл бұрын

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

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

@ExcelForFreelancers

3 жыл бұрын

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

@user-ro6hp4lz3l

3 жыл бұрын

@@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!

@ExcelForFreelancers

3 жыл бұрын

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.

Hey there. awesome videos. Is there a way for this to be done in a user form?

@ExcelForFreelancers

6 жыл бұрын

HI yes there are many great Userform Date Pickers. In this video & download I go over a userform as well: kzread.info/dash/bejne/goB1rJJxfLOdm6g.html

@msaltarelli

6 жыл бұрын

Excel For Freelancers thank you so much! Worked like a gem!

@ExcelForFreelancers

6 жыл бұрын

Great, happy to hear that

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!

@ExcelForFreelancers

6 жыл бұрын

I would use "Center Across Selection' instead of merged cells. This will ensure that you do not have the calendar works well.

@donwilcox7919

6 жыл бұрын

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.....

@ExcelForFreelancers

6 жыл бұрын

Thanks so much Don :)

@donwilcox7919

6 жыл бұрын

Glad to help Jesus

How i can import both time and date pop up picker in same sheet? i tried but it's not working

@ExcelForFreelancers

4 жыл бұрын

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 .. im getting an error as compile error cannot find project or library kindly help

@ExcelForFreelancers

6 жыл бұрын

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.

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?

@ExcelForFreelancers

2 жыл бұрын

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

Can you upload a complete video on school management system ?

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

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

@monicadelcasto4817

6 жыл бұрын

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

@ExcelForFreelancers

4 жыл бұрын

HI and thanks very much Venkat. I have a training on how to share and sync your macro-enabled workbook here: kzread.info/dash/bejne/k3-Kl9WeitDPctY.html Thank you for your Likes, Shares & Comments. It really helps.

@Venkat-sc6kf

4 жыл бұрын

@@ExcelForFreelancers wow great,... Will check it out thank you so much

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.

@ExcelForFreelancers

6 жыл бұрын

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.

@ExcelForFreelancers

6 жыл бұрын

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 жыл бұрын

I just love this "Date Picker", now with weeks starting on Mondays. Thanks again Randy.

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome :)

Thank you so much for replay. Date picker working but date 31 not working. Do you have any solve for 31.

@ExcelForFreelancers

3 жыл бұрын

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.

Sir I have set your date picker in my excel but If I click on date cell, workbook tremble please give me a solution

@ExcelForFreelancers

6 жыл бұрын

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

I cant use it on a merge cell, How can I use on a merge cells? Thanks in advance

@ExcelForFreelancers

4 жыл бұрын

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

Hii how to change date split character (/) to (-) and date format dd-mm-yyyy in this code

@ExcelForFreelancers

3 жыл бұрын

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

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?

@ExcelForFreelancers

2 ай бұрын

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.

@ExcelForFreelancers

2 ай бұрын

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

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

@ExcelForFreelancers

3 жыл бұрын

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

how can i add the date in multiple cell.....Please help me in this

@ExcelForFreelancers

5 жыл бұрын

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

i wait for many hours (not a few minutes) for the email. thanks btw

@ExcelForFreelancers

5 жыл бұрын

Hi sorry you did not receive the email. You can download your free date picker from this link here: bit.ly/FreeExcelUtilities

how should i use it in the userform ?

@ExcelForFreelancers

3 жыл бұрын

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, where to find the text for date picker to copy in my worksheet? Thank you

@ExcelForFreelancers

3 жыл бұрын

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/

@saragalantini6696

3 жыл бұрын

@@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!

@ExcelForFreelancers

3 жыл бұрын

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.

Interesting

@ExcelForFreelancers

17 күн бұрын

Thanks so much Joe. Thank you for your Likes, Shares & Comments. It really helps.

My windows 10. Before Date picker working right now not working date picker. What problem please give idea.

@ExcelForFreelancers

3 жыл бұрын

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.

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.

@ExcelForFreelancers

2 жыл бұрын

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

Sir how can I make my cALENDAR & attach on my user form

@ExcelForFreelancers

3 жыл бұрын

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, 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.

@vishnuvardhanreddy2259

6 жыл бұрын

i am sorry got it now, thanks for great Macro

@ExcelForFreelancers

6 жыл бұрын

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.

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?

@ExcelForFreelancers

2 жыл бұрын

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: kzread.info/dash/bejne/ZX9qmJZ-fNbdoJc.html I hope this helps and thanks so much.

@Paul-ly1pw

2 жыл бұрын

@@ExcelForFreelancers Is it possible for me to just alter the old code so that it stops displaying 2018 and display this year instead?

@ExcelForFreelancers

2 жыл бұрын

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.

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...😔😔

@over-devz

4 жыл бұрын

I want to call date picker and show the pop up when text box are clicked..

@ExcelForFreelancers

4 жыл бұрын

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: kzread.info/dash/bejne/goB1rJJxfLOdm6g.html

@over-devz

4 жыл бұрын

@@ExcelForFreelancers oke thanks you dude..

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

@ExcelForFreelancers

2 жыл бұрын

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.

There is error in ActiveSheet.Shapes("Calendar").Copy How do I solve that. Thanks

@ExcelForFreelancers

4 жыл бұрын

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.

@ajimeeful

3 жыл бұрын

@@ExcelForFreelancers should we download a calendar add-ins or something?

hello, in some case.. the name of month and year going to #NAME.. whats happened? can help me to fix it?

@ExcelForFreelancers

3 жыл бұрын

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.

@ajimeeful

3 жыл бұрын

@@ExcelForFreelancers waiting for group approval

Can you have this several times on one sheet

@ExcelForFreelancers

5 жыл бұрын

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.

Works well, but I get Excel's date Number, not the date.... how do I change that?

@ExcelForFreelancers

6 жыл бұрын

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

Can you teach us to build one from scratch?

@ExcelForFreelancers

Жыл бұрын

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.

Sir, why the dtpicker not work if the sheet in protect mode, thanks much...

@ExcelForFreelancers

6 жыл бұрын

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

@danirahadian6919

6 жыл бұрын

Excel For Freelancers thanks for great response, hi appreciate to you all. Let me try your suggestions. Very big Thanks before....

@ExcelForFreelancers

6 жыл бұрын

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

@danirahadian6919

6 жыл бұрын

it's work, Amazing. Thank you.

@ExcelForFreelancers

6 жыл бұрын

Excellent. So glad to hear that. :)

How to make monday first day of the week?

@ExcelForFreelancers

Жыл бұрын

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.

Hi, Why it have a password?

@ExcelForFreelancers

6 жыл бұрын

HI, No password. It should be open and unlocked. (You may want to add your own password in the future)