How To Add 3 Different Date Picker Calendars in Microsoft Excel [Free Download]
Рет қаралды 93,201
Күн бұрын🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to add 3 different types of calendars in Excel.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/3_Calendars
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:27 - Overview
2:58 - Selection Change Event
14:49 - Conditional Formatting
18:33 - Cell Next Month
19:40 - Cell Today
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #excelcalendar #freecalendar #datepicker
@ExcelForFreelancers 2 ай бұрын
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
@adrianbreckenridge4173 3 жыл бұрын
Awesome! Well explained and the Shape date Picker is brilliant and easy to put into a workbook with the detailed instructions. Thanks!
@ExcelForFreelancers 3 жыл бұрын
For sure, you are very welcome Adrian
@CeliaAlvesSolveExcel 4 жыл бұрын
Hi, Randy! I just installed the shape-based calendar and it is working very well. You did a phenomenal job with the code accounting for a number of different situations, and also with the design details! Thank you so much for sharing this.
@ExcelForFreelancers 4 жыл бұрын
Thanks so much Celia, I do love the shape-based but they can be a bit tricky to work with sometimes. Of course you are an expert, so nothing is tricky for you. I have a new take on a cell-based calendar training coming up in a few days. Similar to the double calendar when you book flights. I hope you will like it.
@CeliaAlvesSolveExcel 4 жыл бұрын
@@ExcelForFreelancers I wil check that new video. I have been playing with the shape based calendar version from this video, making a few tweaks and it's working great!
@macman007747 3 жыл бұрын
Good lesson Randy! Working through your 150 Excel Workbook Library.
@ExcelForFreelancers 3 жыл бұрын
Awesome, thanks so much Rob. I do appreciate that.
@SyedMuzammilMahasanShahi 6 жыл бұрын
Beautiful. Thanks for sharing
@ExcelForFreelancers 6 жыл бұрын
For sure, you are welcome
@VladimirSuazo24 6 жыл бұрын
Hi, just found your channel and it has a really great content; You have done a very good job, congrats. I would like to know if there is a way to link any of these calendars to a pivot chart so I don't have to use slicers for the dates.
@ExcelForFreelancers 6 жыл бұрын
Hi Vladimir thanks for the comment. You could assign the Form or Shape based calendar to any cell or Active X or Form Control. If you use a Form Control you still may want to use a linked cell, even in it's header. Most pivot tables have limits to them as well. You can assign a macro to any cell within your pivot table to open on cell selection which can be helpful in this case. I hope this helps. Please feel free to join our Facebook Group as well. bit.ly/groupexcel
@martinargimon730 3 жыл бұрын
HI randy, Thanks very much for the Calendars. Just a quick question ? Can we bring up/ call any of these calendars within a VBA form ? Thanks in advance . Martin
@ExcelForFreelancers 3 жыл бұрын
Hi and thanks for your comment. You would want to use a form-based date picker when adding calendars to existing userforms, and not the shape-based calendars, which are only for sheets. I hope this helps and thanks so much.
@kenmcmillan2637 5 жыл бұрын
I love your three different calendars and appreciate you preparing. It is possible to use one of these calendars on this file I created which is a 4 week based form, but my company changed accounting periods from a 4 week to a monthly based? The 5th week would change based on the calendar of the year and month and could I tie that 5th week to one of the 3 calendars you created? Thank you.
@ExcelForFreelancers 5 жыл бұрын
Hi Ken, thanks so much for your message. The calendars are all open and unlocked and you can make any changes you like. If you would like to have someone customize this for you please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Create a new post with the words PAID JOB and post your detailed requirements, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@adriantoma9796 6 жыл бұрын
Nice tutorial! PS: I usually show calendar also on double click to make sure it is triggered
@ExcelForFreelancers 6 жыл бұрын
Thanks very much. Double click is also a great option i have used as well.
@alializadeh8195 Жыл бұрын
Thanks
@ExcelForFreelancers Жыл бұрын
You are very welcome and I am happy to help Ali
@MrJunior026 2 жыл бұрын
Hi Randy! Thank you so much for the video! I have a question: when I use the code it's giving me the Run-time error '1004' Method 'Range' of object '_Worksheet' failed when I add multiple cells to the code. I added from cell B3 to cell B67 and it works perfectly but when I try to add cell B68 or another one, it gives me the error mentioned above. Any ideas of how to resolve this?
@ExcelForFreelancers 2 жыл бұрын
Hi Junior, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@jelajahsebanten 2 жыл бұрын
Good sharing👍👍
@ExcelForFreelancers 2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@alomsarker5325 2 жыл бұрын
Excellent
@ExcelForFreelancers 2 жыл бұрын
Thank you very much, I appreciate it
@MrKunal995 4 жыл бұрын
Randy I need your help to put such a calendar for attendance tracking of an employee.
@ExcelForFreelancers 4 жыл бұрын
Hi Kunalj thanks very much for your comment. I have actually already created that in a series of videos in my Employee Manager. You can find that right here: kzfaq.info/get/bejne/rZ6Xia-CnM_clnU.html Thank you for your Likes, Shares & Comments. It really helps.
@vickyhartley835 4 жыл бұрын
can I use this calendar 'within' an existing user form? I have a booking user form and would like to be able to select a date from a pop up.
@ExcelForFreelancers 4 жыл бұрын
Hi Vicky, you can use the Userform Date Picker form for existing userform (not the shape-based and not the sheet-based calendars) I hope this helps and thanks.
@cecilm3720 4 жыл бұрын
Request help: How can I use the in-cell-calendar for a range of cells in my spreadsheet? Thank you. (ex: I need to input a series of dates in cells A20:M20.)
@ExcelForFreelancers 4 жыл бұрын
Hi yes you can Cecil, you can set the range to anything you like. Just use a hidden cell to save the range you have selected, and when a user selects a date in that calendar, add the date to whatever range the user has selected. For more details please post your entire requirements in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel Thanks so much.
@cecilm3720 4 жыл бұрын
Thank you.
@dianacouch2696 5 жыл бұрын
Like the calendar a lot. Ran into an unexpected linking problem: (Using Excel 2013 on native Windows 10 Toshiba laptop.) After using the calendar awhile, I began getting a can't link error, although everything in my workbook worked. Tracked it down to a link between my workbook, and the downloaded workbooks used during install. The linking error happened because I moved those files, thinking they were not needed. But as it turned out, 3 Excel Calendars.xlsm is linked, and through it DatePicker.xlsm is linked. But...when I examine links in my workbook, or in the download workbook, the following is found: If I look at Inquire tab:Workbook Relationship, the diagram shows these links as existing. If I look at Data tab:Edit Links, no such links are shown in order to break them. (When I return the download workbooks to their original location, the error stops. Either way, everything works.) In my workbook, I have CalPopUp as Sheet3 (hidden) and Popup_Calendar Module, so I would think these are enough. Yes? This is important, as the finished workbook will reside on someone else's computer. --- Any suggestions? --- Thanks, Doug
@ExcelForFreelancers 5 жыл бұрын
Hi Doug, I do understand that issue. Sometimes when moving over the calendar the macros assigned don't always get written properly to the new calendar. The CalPopUp sheet contains a calendar as a backup, so this way if your calendar on your sheet gets deleted the backup is copied over (you could manually do this as well) (You just don't want two calendars on the same sheet) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@mdsaiful6294 2 жыл бұрын
Nice video 😊
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Saiful
@NoraRainey 2 жыл бұрын
I am using Microsoft Office 365 and I do not have a Form folder in VBA. Was this removed in Microsoft 365?
@ExcelForFreelancers 2 жыл бұрын
Hi Nora, if you are on a browser version this would not work, also if you are on a Mac there are some limitations. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@om_tandrala 6 жыл бұрын
Can u also make a video on how to create a marquee text in excel without using Microsoft webbrowser as webbrowser doesn't work in Excel 2013 & 2015. I have tried but it doesn't smoothly animate the text because it is reflected after every second and I am not getting how to reflect in milliseconds for smooth animation.
@ExcelForFreelancers 4 жыл бұрын
Thank you for your suggestion. I will do my best
@mdtohamondol199 2 жыл бұрын
Nice
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Toha
@miguelmount7821 5 жыл бұрын
I wanted to create a calendar macro so I could put the date in whatever cell I select. My version of Excel, which is the latest, does not have the Microsoft Date Control. What can I do? Thanks!
@ExcelForFreelancers 5 жыл бұрын
Just download the workbook and follow the training in this video. You have 3 good options here for a Date Picker (download links in the description)
@srikanthkasala7850 6 жыл бұрын
Respected sir, I seen your few of videos of you did one. I inspired a lot and I started practice in beginning am facing little bit to do or complete the task. I to learn some basics of programming of VBA.. Sir can you give a link of your 1st video of VBA. I hope it is helpful to me and who are watching your valuable videos they also gain from you knowledge..... thanking you sir
@ExcelForFreelancers 6 жыл бұрын
HI thanks so much. All of my videos are on my channel here: kzfaq.info In the future I will have some basic VBA classes and videos as well so please keep watching. Also please feel free to join our Facebook Group, with thousands excel experts here: bit.ly/groupexcel
@peterlelkes320 5 жыл бұрын
Is this working on Windows 64 bit and Office 365? Regards Peter from Sweden
@ExcelForFreelancers 5 жыл бұрын
Hi Peter this should work just fine, however if you do run into any issues just post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel so that our members can help you. Thanks very much.
@kennelson3963 2 жыл бұрын
Randy, I'm missing some of the info you show in the Developer tab/Visual Basics area. How can I communicate with you to show you what I'm speaking about?
@kennelson3963 2 жыл бұрын
Specifically I don't have the "Form Calendar" tab you show in your video.
@ExcelForFreelancers 2 жыл бұрын
Hi Ken, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Make sure to download my application using the links in the description. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@DeepakKumar-ms3zu 2 жыл бұрын
Sir can we use the userform calendar in corel draw please tell me
@ExcelForFreelancers 2 жыл бұрын
HI and thanks very much. This only works in Excel. I hope this helps and thanks so much.
@DeepakKumar-ms3zu 2 жыл бұрын
@@ExcelForFreelancers ok thank you sir can you provide popup calendar coding for corel draw software
@T_h_e_Best 4 жыл бұрын
Dear Randy, your video so cool. I want to implemen special Timer 'cutdown' into my excel file. But I faced with issues that Timer connected to cell. When user open the file and based on his name Timer 'cutdowm' must set time up ( 10 min) and start to work. Here is I found the issue: when user making modification in cell Timer is not working.....After to avoid this I try to create my own timer and set up time by formula....this solution works but new issue poped up: this kind of timer works only in one sheet due to textbox.controlsouce coneted only to one sheet to one cell. If i chose other sheet my Timer started but not counting time. Could you help me please, with Timer counting creation which will work in all worksheets and not freazze or stoped and when user activate each o cell for write some data or text into cell? Thank you in advance. Best regard. Best
@ExcelForFreelancers 4 жыл бұрын
Hi you would want to make sure to reference the full sheet in the control source and not just the cell (search google for Excel Control source sheet reference) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@T_h_e_Best 4 жыл бұрын
@@ExcelForFreelancers, ок. Thanks I will join
@Darioq57 4 ай бұрын
Coding meant for calendar to be called from a sheet. How do I call if from another form whit a date entry?
@ExcelForFreelancers 4 ай бұрын
Hi and thanks it would be difficult to know unless I saw your sheet and your goals. Can you please share a screenshot of what you are trying to do in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@JahfaliA 6 жыл бұрын
i got an error when i try to open the first calendar it saying "type mismatch" only the second calendar working plzzzz help me
@ExcelForFreelancers 6 жыл бұрын
Hi it's hard to tell what exactly is the cause however if you join our group and upload the file or screenshot for sure we can help you. Please join our Facebook group here: bit.ly/groupexcel Thanks so much.
@12345charmo 3 жыл бұрын
Hi how do i get the download please
@ExcelForFreelancers 3 жыл бұрын
Hi Mike, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@maxy2032 3 жыл бұрын
it errors out on CheckSheet. Error msg: "Compile error: Sub or Function not defined"
@ExcelForFreelancers 3 жыл бұрын
Hi Max, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
@om_tandrala 6 жыл бұрын
How to make the popup calendar close by pressing Esc button. Instead of using mouse to click on close button, is there any way to close the popup calendar close by pressing Esc button on keyboard. Thanks.
@ExcelForFreelancers 6 жыл бұрын
Its a good question. There are a few options. Please post the question in our group so we can get many different possible solutions. Http://bit.ly/groupexcel
@om_tandrala 6 жыл бұрын
Excel For Freelancers Posted the question in the group. Pls reply if you have any solution for it.
@om_tandrala 6 жыл бұрын
Excel For Freelancers Pls reply
@ExcelForFreelancers 6 жыл бұрын
Please be patient, as I have many requests and tasks as well as responsibilities and I have not been able to double check on the best solution for you just yet.
@fadreen 6 жыл бұрын
Hello this in regards with the popup Calendar that's available for download. After downloaded the files "DATE PICKER SHAPE Based" in that the 27th date or the last row 4th Column doesn't work properly for eg: if we select 27 it shows next date that's 28. Why is it?? Can you please help with the solution for it?? Thank you
@ExcelForFreelancers 6 жыл бұрын
Hi sorry to hear about that it is not working correctly. I would like to take a look at that specific instance so i can see the issue. Perhaps you can join our Excel Facebook Group here: bit.ly/groupexcel , and post your workbook so me and other Excel members can fix the issue for you. Thanks so much.
@fadreen 6 жыл бұрын
Hello thank you for the reply. if its not much of the trouble the group that you mention is linked with facebook login isn't it? But unfortunately i don't use facebook. So, if its not much to ask can you provide the solution on this platform itself please. This is the link you had provided to one Kellie with this link (bit.ly/3_Cal_WbDl) which i also downloaded & found this problem, please if you help on this will be of great helps. Hope to hear from you asap. Thank you in advance.
@ExcelForFreelancers 6 жыл бұрын
Hi thanks for your comment. I would recommend using the Form Based Date picker as the shape based pick may have issues in certain workbooks. Thanks for your patience.
@fadreen 6 жыл бұрын
Hello is it possible to get the form based date picker link from where i could download it?? waiting for your reply. Thank you
@ExcelForFreelancers 6 жыл бұрын
Hi you already have it in the same workbook as the shape based (there are 3 calendars with the workbook in the above video, one is a form based)
@hilarysutherland682 2 жыл бұрын
Trying the first form based calendar. I have no "form" on the right I really wanted this to work. Please help
@ExcelForFreelancers 2 жыл бұрын
Hi Hilary, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@benosborne413 12 күн бұрын
Calendar one. How do I add it to multiple sheets in on workbook?
@ExcelForFreelancers 11 күн бұрын
Hi and thanks you can just copy the sheet code from one sheet to another and adjust the range. I hope this helps and thanks .
@excelavon 6 жыл бұрын
I want to get this file I have tried 2 times but i have not got it
@ExcelForFreelancers 6 жыл бұрын
Hi very sorry to hear that you were unable to get it. Just click this link to download the ZIp file: bit.ly/3_Cal_WbDl
@mmowgli 10 ай бұрын
Hi Randy is there a way to do this on a mac ?
@ExcelForFreelancers 10 ай бұрын
Hi and thanks, I believe so however there may be code updates required You can check for the type of updates for a Mac here: www.macexcel.com/ I hope this helps and thanks so much.
@MarkCams 6 жыл бұрын
Sir, How could a pay for you to build a profile database for me?
@ExcelForFreelancers 6 жыл бұрын
Hi thanks for your message. I have been focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, I have created a Facebook group with 7000 Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@agvs85131 2 жыл бұрын
Hello! I have an error on calendar when I choose month. In Private Sub Build_Calendar() If i < CInt("01/" & Weekday((CB_Mth.Value) & "/" & (CB_Yr.Value))) Then the error is - Data type error
@ExcelForFreelancers 2 жыл бұрын
HI make sure that the values in your fields are numbers and that the field names are correct I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@agvs85131 2 жыл бұрын
@@ExcelForFreelancers Hello when I want to register to facebook group then message apperas This Page Isn't Available Right Now
@agvs85131 2 жыл бұрын
@@ExcelForFreelancers HI make sure that the values in your fields are numbers and that the field names are correct. You think about your file 3_Excel_Calendars? I am not change these file. But error occur immediately when I click on E7 cell. Type mismatch runtime error 13.
@ExcelForFreelancers 2 жыл бұрын
Hi George if you have any issues joining the group please email the admin angeli@ExcelForFreelancers.com I hope this helps and thanks so much.
@shafiqulislam-fj8mh 6 жыл бұрын
your video is very excellent. please give me vb cord & project file. plz plz
@RandyAustin 6 жыл бұрын
shafiqul islam Hi thanks for your message. You can download the complete workbook with code from here : www.excelforfreelancers.com/3-excel-calendars-download
@shafiqulislam-fj8mh 6 жыл бұрын
thank you so much
@ExcelForFreelancers 4 жыл бұрын
For sure, you are very welcome
@Mecan7 10 ай бұрын
Cuando descargo la plantilla, en mi correo sale como si lo hubiera mandado pero no aparece nada
@ExcelForFreelancers 10 ай бұрын
Hola y gracias. A veces esto puede aparecer en un teléfono, sin embargo, si recibe el correo electrónico en la computadora, no debe estar en blanco. Leí el correo electrónico que me enviaste y ese correo electrónico no estaba en blanco, así que descárgalo en tu computadora y debería funcionar bien.
@rycerzjedi123 3 жыл бұрын
Type data mismatch in form pop-up
@ExcelForFreelancers 3 жыл бұрын
Hi Michal, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@kailashsoni676 Жыл бұрын
Hello sir , ❤️ Can I use these cal... In userform?
@ExcelForFreelancers Жыл бұрын
Hi and thanks. The one calendar that is made in a userform can be used in a userform, the other two cannot. I hope this helps and thanks so much.
@kailashsoni676 Жыл бұрын
@@ExcelForFreelancers fine sir Thanks Have a great day
@colbywilliamson3393 Жыл бұрын
Where can I download the calendarfrm user form?
@ExcelForFreelancers Жыл бұрын
Hi Colby, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@mohamedhasanbasari 6 жыл бұрын
How to do on Userform with datepicker
@ExcelForFreelancers 6 жыл бұрын
The First Option of the 3 options is a Userform Datepicker. Make sure you download your free copy with the links in the description.
@MarkCams 6 жыл бұрын
I'm using it for my Job.. and I want to use MS excel 2007..
@ExcelForFreelancers 6 жыл бұрын
2007 Should work for most of my applications. (I design everything in 2010). If you have a specific issue we can help in our Excel For Freelancers Facebook Group. (bit.ly/groupexcel )
@om_tandrala 6 жыл бұрын
I had used the first one which is form calendar. But when i select a date and again visit the cell to change date, the form calendar is automatically switching to today's. Pls tell me how to stop the calendar from switching to today's month. Pls reply @Excel for freelancers
@ExcelForFreelancers 6 жыл бұрын
The Form Calendar (first One) will always have a small square around the current date however you are free to enter any date you want. The current date is not automatically entered into the cell date.
@om_tandrala 6 жыл бұрын
Excel For Freelancers I wants to know how to stop the calendar from switching to current month and year. When i enter a date in different month and year, the calendar should fix to that month and year if i again visit that cell.
@ExcelForFreelancers 6 жыл бұрын
Also if you go into the code for the calendar (double click the calendar) you see: ThisDay = VBA.DateTime.Date Change to: ThisDay = Sheet1.Range("A1").Value Make sure instead of A1, you use the cell that contains your date
@ExcelForFreelancers 6 жыл бұрын
Make sure you see my response above. This will solve your issue
@om_tandrala 6 жыл бұрын
Excel For Freelancers The above one has solved the issue. But i am getting am error whenever the linked cell is empty. If there is already a date in that cell then it is working fine, But if the cell is empty it is not working because the macro is not getting which month it should display. Pls tell how to fix that. If a date is entered the calendar must show according to that month and year but if the cell is empty the default should be set to today's date. Thanks in advance.
@ronolds6505 2 жыл бұрын
I tried downloading the "Free" workbook for three types of pop-up calendars. And nothing arrived in my email. ???? It seems I need to purchase 200 workbooks in order to get the "free" calendar workbook. ????
@ExcelForFreelancers 2 жыл бұрын
Hi Ron, certainly you do not need to make the purchase. Free is Free. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@sherryasd 6 жыл бұрын
I thinks one more disadvantage of second option should be mentioned. Year Selection option is not available
@ExcelForFreelancers 5 жыл бұрын
Hi thanks, but a year option could easily be added. Thanks for your feedback.
@user-sg6zh8nb5l 2 жыл бұрын
Where is that download for those of us who started late to excel?
@ExcelForFreelancers 2 жыл бұрын
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@AsoDaramary 4 ай бұрын
hi iwant calendar form
@ExcelForFreelancers 4 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@kelliereviews5341 6 жыл бұрын
You guys made a mistake, instead of having 3 excel calendars, the download for the forms and the tutorials. You have "Fade Out Messages" workbook and tutorials In both places 🤔. Can you fix this. I would like to learn how to do calendars in excel.😊
@ExcelForFreelancers 6 жыл бұрын
Hi thanks so much. Yes I did see some issue with that (before it was working but the mail service is making some changes) Anyways I will get it fixed right away, but you can download the workbook directly from this link: bit.ly/3_Cal_WbDl
@LarsIngeHolen 4 жыл бұрын
How to make monday the first day of the week?
@ExcelForFreelancers 4 жыл бұрын
Hi Lars you can update the Weekday function inside the formulas on the hidden pop-up sheet I hope this helps and thanks.
@AsoDaramary 4 ай бұрын
I WANT LINK
@ExcelForFreelancers 4 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Excel For Freelancers
Рет қаралды 656 М.
Excel For Freelancers
Рет қаралды 36 М.
Фото радужки глаза Владимир ScreenEyes
Рет қаралды 6 МЛН
Giselemiranda_ofc
Рет қаралды 30 МЛН