Hi Randy! That looks awesome! I was wondering if I would be able to build this on a Mac or a similar version of it since it requires a UserForm. Thanks!
Hi and thanks. Mac's cannot use ActiveX components so if you are using a Mac i would go with something like Parallels which will mimic the Windows environment inside a Mac www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.
Excellent Randy. For those who have date in spanish format in computers consider to change in CalendarFrm the code in Build_Calendar() from Controls("D" & DayNumb).ControlTipText = CalDate 'Set Calendar Date (formatted to machine format) to Controls("D" & DayNumb).ControlTipText = Format(CalDate, "yyyy-mm-dd") 'Set Calendar Date (formatted to machine format) In this way when you select, for instance, July 11, the cell saves 11/07/204 in spanish format not 07/11 that is November 7.
Thanks so much Santi. I think this Date picker has huge potential but I still need to spend time on it for different date formats. The idea is for the datepicker to match the existing system date format, however i want to upgrade it to the selected cell format. So for example, if we make it dynamic for any date format around the world. You may also want to use different date formats in your workbook, so I have some work to do to make it more inclusive of all regional date formats. I hope this helps and thanks so much.
I also had a problem like this. I resolved it my modifying the form code for each button press to use the DATEVALUE function... Private Sub D1_Click() 'this sub and the ones following represent the buttons for days on the form 'retrieves the current value of the individual controltiptext and places it in the active cell ActiveCell.Value = DateValue(D1.ControlTipText) Unload Me End Sub
what a coincidence when I am already working on an accounting program and I needed a date picker, I have been following your videos since long and the old date picker was giving same problems as you mentioned in the beginning, but this one is awesome...
Great thanks so much. I am so happy to hear that. I think this date picker still needs a few small udpates for more regional settings and I will be adding features such as holidays and more languages and a few other updates on Patreon next week www.patreon.com/ExcelForFreelancers Thanks again for your support
Yes I am adding Holidays, with custom holiday color. I am also adding how to add this date picker to a userform, as well as languages in the toolbar days, and a lot more on Patreon next Monday. Thanks again
Yes perfect. I have already created it and recorded it and you will love the solution that I came up with. I have already recorded a 40 minute video for Patreon www.patreon.com/ExcelForFreelancers Thanks again for the great suggestions
Excellent content, Your expertise in Excel is inspiring. Could you share tips on establishing myself as an Excel freelancer and attracting clients? Thanks a lot!
HI and thanks. Absolutely. If you are interested to learn more about creating Excel Applications and selling them or creating solutions for clients you would enjoy my Mentorship program where I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ If you would like to learn more about the Freelancing aspect you can join my Freelancers Academy Masterclass here www.excelforfreelancers.com/sp/freelancers-academy-masterclass/ I hope this helps and thanks so much.
Great.. is it possible to add in this video how this datepicket can be added in the userform. If we change date in userform then it also updates in the excel cell
HI and thanks yes you can just add a button in a userform and with that button on click write something like 'DatePickerFrm.show' that is all that is needed. I hope this helps and thanks so much.
Hi, you can download this file using the links in the description under the word DOWNLOAD. Every single one of my videos has a free download. I hope this helps and thanks.
Hi Randy. Thanks for this excellent piece of code. May I suggest reversing the colors for the selected date (instead of using italics). Background to foreground and vice versa. Also, I changed the code to use the DATEVALUE function on each of the 42 key presses. Thanks again. Michael
Very good Michael. Thanks so much and I am also making some updates on this one to include custom holidays and other features for Patreon next week. Thank you for your Likes, Shares & Comments. It really helps.
Maybe you could add languages that aren't Latin character based, Chinese, Arabic, Hebew etc. I believe your method being table based would work since the characters in the table could be added as unicode symbols and may need ChrW to implement but once built maybe not needed if the character string is fixed. However there could be a right to left property needed to display the element correctly at least on cells. This is a direction format property and I have used it to insure Hebrew chars add to strubt right to left. (Just remember string position 1 is on the right.) I am still using English keyboard but character insertion based on code appears to work correctly when the direction is flipped. And I believe it will work in form fields if the source of the field is specified as such but this could be a bug a boo if it can't display in the proper orientation. So the issue there is while cells can be formatted for direction, I do not know about form field properties.
Hi Malcolm, thanks for your idea. I will certainly consider it if there are enough requests however I had avoided it to minimize errors and bugs in which those language packs were not installed on machines. I hope this helps and thanks so much.
@@ExcelForFreelancers Actually a language pack is not required and can all be done with Unicode characters. Cell positioning of Unicode Chars for superimposed markings is handled within the Unicode and implementation of these characters by Excel. Right to left can be handled by setting a cell property. As I noted, not sure about how this all works out in form elements but I believe it works there too since I did an app for editing Hebrew text and the form used to display the string came directly from a source cell. Both cell and form elements appeared to work okay. So lack of language packs not an issue for this type of work. What you can't do is look for the second language in standard Excel interface features but this requires Excel to open with the primary language chosen other than English and that is a mess.
Thanks for the update Malcolm and details. I still have a lot of bugs being reported in this Date Picker, so I will have to tackle those before turning my attention to other languages. I hope this helps and thanks so much.
Hi Randy, This is one of the very best trainings I've ever attended! I was wondering if it is possible to add a feature to allow the Calendar to close if you click on a cell that is not the active cell?
Hi and thanks so much. There are a few options you can choose with that. If you set the Userform property 'ShowModal' to True, you won't be able to select any other cell while it is open. If you set it to False, then you can select another cell If you select another cell and you want it to close, you can use the Selection_Change event, something like this If CalendarFrm.Visible = True then CalendarFrm.Hide I hope this helps and thanks so much.
OMG, this is awesome. Never seen something so simple to add to my workbooks. Will be looking at the code, but it is way beyond my current skills, Also more than any other I have tried and used. This guy is a god. Is there an option / way to get this great date picker to also work on a userform?
Hi and thanks so much. Yes it can also be added to a userform. I show you how to do this, along with adding Holidays, on my Patreon update of this application here: www.patreon.com/posts/date-picker-add-104582398 I hope this helps and thanks so much.
Dear Randy, the dp looks great thanks, but it is not running at all. It only shows the disable dp icon, but not the "select start day", and nothing shows up (I formatted as date)...Any idea? Thanks and cheers chris
Hi Chris, make sure you have my newest update (Same download link) Also make sure you have enabled macros by right clicking the add-in after download You also may want to remove other addins and be sure that the one you are installing is the newest one I hope this helps and thanks so much.
Hi Randy - excellent work - thank you. However, my code gives me a run-rime error '13' type mismatch on the first line of the DayNumb loop. I also notice that if I hover over the DateFormat statement above this, the date format shows as "0d/0m/yyyy".
HI and thank so much for your feedback. I am going to change my version, based on your feedback, and upload the update. Much appreciated and thanks so much
HI and thanks. Yes, in fact both the Months and the Days in the toolbar have been updated to multiple languages. I have just finish this update and will release it in about 15 hours on my Patreon platform (each week I release an updated version of the original video as well as an updated template) Feel free to join us on Patreon here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as CalendarFrm.Show which will display the userform Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead. You may want to set the ShowModal property to False which allows multiple userforms at once I hope this helps and thanks so much.
For sure, you are very welcome Rudi and thanks so much for your help. A few people have reported some regional issues since there are so many date formats around the world, but I am working through them. Thanks again for all of your help and support.
Also i had an issue when editing this video and 12 minutes got cut around the 15 minute mark, where i explained more detail about how to get into the addin (although you already know all of that)
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 randy there a certain point of sale system I have been trying to create which is for a pharmacy shop everything I have done it correctly including ite inventory system, dashboard but there is a feature that I could like you to help me with which is to use the loyalty card points system as a discount mode of payment and also automated tracking of the expiry date of the medicine try to create one using vba
HI Keith, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Hi and thanks, yes its certainly possible, you can just format whatever cell you want the date to go into with a custom format such as "dd mmmm yyyy" Add this into the normal cell formatting and it should work just fine. I hope this helps and thanks so much.
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as CalendarFrm.Show which will display the userform You may want to set the ShowModal property to False which allows multiple userforms at once Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead. I hope this helps and thanks so much.
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as CalendarFrm.Show which will display the userform Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead. You may want to set the ShowModal property to False which allows multiple userforms at once I hope this helps and thanks so much.
Thanks. I followed instructions and it is giving a debug error. Maybe I must get rid of your previous Date Picker. When I install it asks if i want to replace your old one. Yes but error
Hi and thanks. Yes you will want to remove all other add-ins before installing this one. There still may be some small bugs on regional date formats that some people are having so i am going to work through those bugs as well. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks. I have now made more updates and you can download it again from the same link as before (just rename the new one so you can know the different) Please try it and let me know. Thank you for your Likes, Shares & Comments. It really helps.
For sure, you are very welcome. I am adding Holidays, with custom holiday color. I am also adding how to add this date picker to a userform, as well as languages in the toolbar days, and a lot more on Patreon next Monday. www.patreon.com/ExcelForFreelancers Thanks again
HI and thanks this may be an issue with date formats and your regional settings. If you run the macro inside the UserForm_Initialize using F8 stepping through the code, the whicheve line has the issue will appear, then I can know a bit more about the bug. (Please feel free to send me screenshots after you perform the above actions) Randy@ExcelForFreelancers.com
Thanks so much, can you let me know what was the format before and what you changed it to? This will help me make some updates to the code inside the Date Picker. Thanks again
HI and thanks so much. This one will work in any workbook that is opened, can be turned on and off, and will work in 21 different languages. I am also adding holidays on our Patreon platform in about 15 hours from now (www.patreon.com/ExcelForFreelancers ) I hope this helps and thanks so much.
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.
![How To Create Your Own ChatGPT AI Assistant Add-In For Free In Excel [+ FREE Download]](http://i.ytimg.com/vi/S17cYc6oKMw/mqdefault.jpg)
![How To Create Your Own ChatGPT AI Assistant Add-In For Free In Excel [+ FREE Download]](/img/tr.png)
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
Hi Randy! That looks awesome! I was wondering if I would be able to build this on a Mac or a similar version of it since it requires a UserForm. Thanks!
Hi and thanks. Mac's cannot use ActiveX components so if you are using a Mac i would go with something like Parallels which will mimic the Windows environment inside a Mac www.excelforfreelancers.com/go/rwm-parallels-YTDesc
I hope this helps and thanks so much.
Good job. Thank you very much for everything you do for us. May God bless you in all your activities.
Thank you so very much, I really appreciate that, very kind of you
Excelente, me fascina su trabajo y las cosas que crea en Excel 👏👏👏👏, he visto y construido varios calendarios en VBA, pero usted sr va a otro nivel 😁
Muchas gracias, realmente lo aprecio y estoy feliz de poder ayudar y compartir.
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. Thanks again and much appreciated
Thanks for all of awesome work for us. Anxiously waiting for this wonderful video
Thanks so much. I appreciate that and happy to help and share.
Excellent Randy.
For those who have date in spanish format in computers consider to change in CalendarFrm the code in Build_Calendar()
from
Controls("D" & DayNumb).ControlTipText = CalDate 'Set Calendar Date (formatted to machine format)
to
Controls("D" & DayNumb).ControlTipText = Format(CalDate, "yyyy-mm-dd") 'Set Calendar Date (formatted to machine format)
In this way when you select, for instance, July 11, the cell saves 11/07/204 in spanish format not 07/11 that is November 7.
Thanks so much Santi. I think this Date picker has huge potential but I still need to spend time on it for different date formats. The idea is for the datepicker to match the existing system date format, however i want to upgrade it to the selected cell format. So for example, if we make it dynamic for any date format around the world.
You may also want to use different date formats in your workbook, so I have some work to do to make it more inclusive of all regional date formats.
I hope this helps and thanks so much.
I also had a problem like this. I resolved it my modifying the form code for each button press to use the DATEVALUE function...
Private Sub D1_Click()
'this sub and the ones following represent the buttons for days on the form
'retrieves the current value of the individual controltiptext and places it in the active cell
ActiveCell.Value = DateValue(D1.ControlTipText)
Unload Me
End Sub
Hi and thanks. I have now modified the code more. If you download it again it should work better.
what a coincidence when I am already working on an accounting program and I needed a date picker, I have been following your videos since long and the old date picker was giving same problems as you mentioned in the beginning, but this one is awesome...
Great thanks so much. I am so happy to hear that. I think this date picker still needs a few small udpates for more regional settings and I will be adding features such as holidays and more languages and a few other updates on Patreon next week www.patreon.com/ExcelForFreelancers
Thanks again for your support
@@ExcelForFreelancers you are amazing sir, please Add more features to the date picker
Yes I am adding Holidays, with custom holiday color. I am also adding how to add this date picker to a userform, as well as languages in the toolbar days, and a lot more on Patreon next Monday. Thanks again
@@ExcelForFreelancers exactly what I want.. how to use this in a userform.. amazing sir
Yes perfect. I have already created it and recorded it and you will love the solution that I came up with. I have already recorded a 40 minute video for Patreon
www.patreon.com/ExcelForFreelancers
Thanks again for the great suggestions
Thanks
For sure, you are very welcome and happy to help
That's great,,, I am waiting............... Love you Sir
Thank you so very much, I really appreciate that
Excellent content,
Your expertise in Excel is inspiring. Could you share tips on establishing myself as an Excel freelancer and attracting clients? Thanks a lot!
HI and thanks. Absolutely. If you are interested to learn more about creating Excel Applications and selling them or creating solutions for clients you would enjoy my Mentorship program where I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
If you would like to learn more about the Freelancing aspect you can join my Freelancers Academy Masterclass here www.excelforfreelancers.com/sp/freelancers-academy-masterclass/
I hope this helps and thanks so much.
Hello
Hi Oliver, thank you for your Likes, Shares & Comments. It really helps.
Great.. is it possible to add in this video how this datepicket can be added in the userform. If we change date in userform then it also updates in the excel cell
HI and thanks yes you can just add a button in a userform and with that button on click write something like 'DatePickerFrm.show'
that is all that is needed. I hope this helps and thanks so much.
Great job, Can not wait .....
Thank you so very much, I really appreciate that and I hope you enjoyed the traiing
Thank you so much sir for this amazing video
Also thank you for giving us free download
It would be great if you disable the off month buttons
Hi, you can download this file using the links in the description under the word DOWNLOAD. Every single one of my videos has a free download. I hope this helps and thanks.
Thanks! Great as usual Randy!
Thank you so very much, I really appreciate that
Hi Randy. Thanks for this excellent piece of code. May I suggest reversing the colors for the selected date (instead of using italics). Background to foreground and vice versa. Also, I changed the code to use the DATEVALUE function on each of the 42 key presses.
Thanks again.
Michael
Very good Michael. Thanks so much and I am also making some updates on this one to include custom holidays and other features for Patreon next week.
Thank you for your Likes, Shares & Comments. It really helps.
Maybe you could add languages that aren't Latin character based, Chinese, Arabic, Hebew etc. I believe your method being table based would work since the characters in the table could be added as unicode symbols and may need ChrW to implement but once built maybe not needed if the character string is fixed. However there could be a right to left property needed to display the element correctly at least on cells. This is a direction format property and I have used it to insure Hebrew chars add to strubt right to left. (Just remember string position 1 is on the right.) I am still using English keyboard but character insertion based on code appears to work correctly when the direction is flipped. And I believe it will work in form fields if the source of the field is specified as such but this could be a bug a boo if it can't display in the proper orientation. So the issue there is while cells can be formatted for direction, I do not know about form field properties.
Hi Malcolm, thanks for your idea. I will certainly consider it if there are enough requests however I had avoided it to minimize errors and bugs in which those language packs were not installed on machines. I hope this helps and thanks so much.
@@ExcelForFreelancers Actually a language pack is not required and can all be done with Unicode characters. Cell positioning of Unicode Chars for superimposed markings is handled within the Unicode and implementation of these characters by Excel. Right to left can be handled by setting a cell property. As I noted, not sure about how this all works out in form elements but I believe it works there too since I did an app for editing Hebrew text and the form used to display the string came directly from a source cell. Both cell and form elements appeared to work okay. So lack of language packs not an issue for this type of work. What you can't do is look for the second language in standard Excel interface features but this requires Excel to open with the primary language chosen other than English and that is a mess.
Thanks for the update Malcolm and details. I still have a lot of bugs being reported in this Date Picker, so I will have to tackle those before turning my attention to other languages. I hope this helps and thanks so much.
Hi Randy, This is one of the very best trainings I've ever attended! I was wondering if it is possible to add a feature to allow the Calendar to close if you click on a cell that is not the active cell?
Hi and thanks so much. There are a few options you can choose with that. If you set the Userform property 'ShowModal' to True, you won't be able to select any other cell while it is open. If you set it to False, then you can select another cell
If you select another cell and you want it to close, you can use the Selection_Change event, something like this
If CalendarFrm.Visible = True then CalendarFrm.Hide
I hope this helps and thanks so much.
OMG, this is awesome. Never seen something so simple to add to my workbooks. Will be looking at the code, but it is way beyond my current skills, Also more than any other I have tried and used. This guy is a god.
Is there an option / way to get this great date picker to also work on a userform?
Hi and thanks so much. Yes it can also be added to a userform. I show you how to do this, along with adding Holidays, on my Patreon update of this application here: www.patreon.com/posts/date-picker-add-104582398
I hope this helps and thanks so much.
رائع جدا برنامج عظيم .
Thank you so very much, I really appreciate that
Can not wait for this...
Great, thanks so much, I am sure you will enjoy the training. Thanks again.
Dear Randy, the dp looks great thanks, but it is not running at all. It only shows the disable dp icon, but not the "select start day", and nothing shows up (I formatted as date)...Any idea? Thanks and cheers chris
Hi Chris, make sure you have my newest update (Same download link) Also make sure you have enabled macros by right clicking the add-in after download
You also may want to remove other addins and be sure that the one you are installing is the newest one
I hope this helps and thanks so much.
Can the date picker works when the working sheet is protected as well?
Hi and thanks, yes for sure it can. Just make sure the cell in which the date is added is not protected. I hope this helps and thanks so much.
Hi Randy - excellent work - thank you. However, my code gives me a run-rime error '13' type mismatch on the first line of the DayNumb loop. I also notice that if I hover over the DateFormat statement above this, the date format shows as "0d/0m/yyyy".
OK - I managed to fix it by changing the date under Regional Date Format to "05" and "03". It then works.
HI and thank so much for your feedback. I am going to change my version, based on your feedback, and upload the update. Much appreciated and thanks so much
How do you set dateformat?
Hi and thanks, I share that with you in the training, so please make sure to watch the entire training. I hope this helps and thanks so much.
I have set the language to Polish, but the names of the months are displayed in English.
Can this be changed?
HI and thanks. Yes, in fact both the Months and the Days in the toolbar have been updated to multiple languages. I have just finish this update and will release it in about 15 hours on my Patreon platform (each week I release an updated version of the original video as well as an updated template)
Feel free to join us on Patreon here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Hi Randy can you use this on a Userform
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as
CalendarFrm.Show
which will display the userform
Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead.
You may want to set the ShowModal property to False which allows multiple userforms at once
I hope this helps and thanks so much.
Watching your tutorial video now. achieved.
Looks very good. Thank you for mentioning me.
Rudi from BE
For sure, you are very welcome Rudi and thanks so much for your help. A few people have reported some regional issues since there are so many date formats around the world, but I am working through them. Thanks again for all of your help and support.
Also i had an issue when editing this video and 12 minutes got cut around the 15 minute mark, where i explained more detail about how to get into the addin (although you already know all of that)
Hi, I have tried numerous times to download the workbook, but nothing is being sent to my email?
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
@@ExcelForFreelancers Thanks for assisting. Got it.
Hi randy there a certain point of sale system I have been trying to create which is for a pharmacy shop everything I have done it correctly including ite inventory system, dashboard but there is a feature that I could like you to help me with which is to use the loyalty card points system as a discount mode of payment and also automated tracking of the expiry date of the medicine try to create one using vba
HI Keith, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
Randy, thank you for all you do.
For sure, you are very welcome and I am happy to help and share
Hi Randy,
Is it possible that the output date is ie. "15 May 2024"? And where do I add this in code?
Hi and thanks, yes its certainly possible, you can just format whatever cell you want the date to go into with a custom format such as
"dd mmmm yyyy"
Add this into the normal cell formatting and it should work just fine.
I hope this helps and thanks so much.
How can I use this in userform?
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as
CalendarFrm.Show
which will display the userform
You may want to set the ShowModal property to False which allows multiple userforms at once
Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead.
I hope this helps and thanks so much.
Hi and thanks very much. You can create a button in your userform to show the datepicker form such as
CalendarFrm.Show
which will display the userform
Since the datepicker is programmed to place the date in the activecell, you would want to program it to place the date in a userform field instead.
You may want to set the ShowModal property to False which allows multiple userforms at once
I hope this helps and thanks so much.
Thanks. I followed instructions and it is giving a debug error. Maybe I must get rid of your previous Date Picker. When I install it asks if i want to replace your old one. Yes but error
Hi and thanks. Yes you will want to remove all other add-ins before installing this one. There still may be some small bugs on regional date formats that some people are having so i am going to work through those bugs as well.
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thanks. I have removed all and install again. Same. Will wait for the bugs to go away. Thanks for great training
Hi and thanks. I have now made more updates and you can download it again from the same link as before (just rename the new one so you can know the different)
Please try it and let me know. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hi, Thanks. Tried it and it is working. Thanks a Million.
For sure, you are very welcome. I am adding Holidays, with custom holiday color. I am also adding how to add this date picker to a userform, as well as languages in the toolbar days, and a lot more on Patreon next Monday.
www.patreon.com/ExcelForFreelancers
Thanks again
Randy, I get an error message when I click on the cell . The code stops at " With CalendarFrm" and the date picker does not show.
HI and thanks this may be an issue with date formats and your regional settings. If you run the macro inside the UserForm_Initialize using F8 stepping through the code, the whicheve line has the issue will appear, then I can know a bit more about the bug. (Please feel free to send me screenshots after you perform the above actions) Randy@ExcelForFreelancers.com
@@ExcelForFreelancers 😀 Thanks Randy, It works after I changed the date format.
Thanks so much, can you let me know what was the format before and what you changed it to? This will help me make some updates to the code inside the Date Picker.
Thanks again
I have better than this one. which is a very simple one but this one seems whole Excel to be Programmed.
HI and thanks so much. This one will work in any workbook that is opened, can be turned on and off, and will work in 21 different languages. I am also adding holidays on our Patreon platform in about 15 hours from now (www.patreon.com/ExcelForFreelancers )
I hope this helps and thanks so much.
i cant download the template file
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.