You have answered SO many of my questions and struggles of the past 6 months with this video. I can't thank you enough! So excited to use this long weekend to build some awesome new projects now that I can store data in my add-ins. The date picker will be really helpful too! Thank you!
That is so great to hear. I also love building add-ins and its kinda new for me too. So I will be creating more and more. Thank you for your Likes, Shares & Comments. It really helps.
I would love to have a tutorial on the date picker, so that I can be used in the worksheet and another form. I have several workbooks with forms where I’ve been trying to do just that.
Yes great thanks I am going to create that very soon. I think i will also make some nice updates to the addin as well so that it is even better than what I have shared in this training. Thank you for your Likes, Shares & Comments. It really helps.
Hi Ron, thanks for your comment. Add-ins are great for something you may want to run while other workbooks are open. For example I just created a Date Picker add-in which can be used as soon as a new workbook is open, which can't be done with a Personal workbook. You can see that here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html I hope this helps and thanks so much.
Love you videos Randy... do you have any video where we can call a command through VBA in an add-in (VBA will execute a command in the add-in rather than manually going in to Add-in and clicking on the command)
Hi and thanks for your comment. I believe I cover this in my Date Picker add-in here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html I also have a Share & Sync add-in coming next Tuesday here: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html I hope this helps and thanks so much.
Slick stuff Randy. If you do the datepicker deep dive can you include how you might use it in a spreadsheet that is used by multiple users in one location on a shared workbook. Or did i miss it?
Hi Larry, thanks so much. I have had a few questions on the date-picker so I think I will work on it today and have it ready next week. This add-in should work well on any workbook installed on, even if it is a shared workbook. Do you foresee any conflicts that I should address during the video?
The only question is if it is on a server or onedrive that is shared with other users. Do they all have to have the blame on their desktop or under options adding you can create a directory for custom add ins and assign then. It would I guess be the same with any add in. E.g. Office manager is entering say PO and Plant manager is doing receipt of goods. Both would use date picker in same spreadsheet but 2 different machines. Make sense or am I clueless?
When using the correct Share & Sync that i share here: th-cam.com/video/f_1HsR9305I/w-d-xo.html Each user has their own, independent, application, and only the data is shared between users. So there is no issue with each user having their own addins which do not affect one another. Even if two users used the same exact file, such as sharing the file via a shared folder, each user would still use their own, unique add-in, and the addin would be mapped to a folder on their computers. I hope this helps and thanks so much.
Thank you Randy for these videos and workbooks. I have been downloading the videos and using them to reinforce the teaching of the video. I have not been able to find out how to download the workbook for the first part of the video, but only the BONUS workbook. Please tell me how to get that first workbook. Thank you
Hi and thanks for your comment. The template for the first part of the video was almost nothing, not much coding and almost nothing in the workbook so i did not make it available. There was not much on it actually however you can download it from the following link: www.dropbox.com/scl/fi/f08juc0a3ns1qgvnir7u2/Addin_Details.xlsx?rlkey=sep3r7f6rauci2clqzrfpog5n&dl=1 I hope this helps and thanks so much.
tnx Randy, great work. Question: I have the dutch version of excel and the european date = dd/mm/jj. So this datepicker doesn't work for me. What do I have to change in VBA?
HI and thanks so much. You can modify the code to recognize the date picker format however consider modifying this line code here If IsDate(Target.Value) Or Target.NumberFormat Like "*yy*" Or Target.NumberFormat Like "*dd*" Or Target.NumberFormat Like "*mm*" Then based on your date format Please let me know what you found that works so i can make the updates I hope this helps and thanks so much.
Thank you @ronge7916 and @madwelho I will be making modifications to the code and we will be going over it in detail within the next training so that it works on more regional dates. I will make updates so that it works within your region as well. I hope this helps and thanks so much.
Hi Randy, thanks for sharing all your work. You guys are the best! I have downloaded the AddIn but it gives me an error Type Mismatch and it brings me to the Line: “With CalendarFrm” (Object variable or With block variable not set) Why is this error?
Hi and thanks for your comment. This could mean that the date picker will not work for your regional settings on dates. I Have a new training with an updated date picker that may work coming this Tuesday here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html You can also test out this new Date picker here: www.dropbox.com/scl/fi/ydvc9xgumr2wzngk0sjju/DatePicker_Add-In.xlam?rlkey=0npky72i6sdbcav8po3ip2wtl&dl=1 Please let me know if the updated one solves the issue
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps. Tobaye. (make sure you download the bonus. You will love it)
Randy If the sheet is set to the default zoom of 100%, the date picker pops up as you say it will, however if the zoom is set higher or lower than the 100% it move, Up >100% and down from the 100% and it is gone from the screen, since I started writing this I have changed the format of the column and got it back onto the screen but the above still applies.
Hi Malcolm, thanks very much. You would need to adjust the points to pixels code based on the current zoom level. To extract the current zoom level you could use ActiveWindow.Zoom You would then need to incorporate this into the formula, and modify it until the positioning is correct. I hope this helps and thanks so much.
WOW. So amazing. Thanks so much. I can't tell you how much I appreciate that. Your kindness and generosity are incredible. Let me know if you want me to build anything and share it on TH-cam if i have not done so already
Hi and thanks for you comment. I have many VBA Basic trainings. Is there a specific TH-cam one you want to see or you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
Hello Randy, Very useful video and a magnificent add-in you offered I live in Belgium (Western Europe) and our date notation is "dd/mm/yyyy". I installed your add-in but it doesn't work for our date notation. After looking into the code, I think the error happens in the SUB Build_Calendar in the following code : If I < Weekday((CB_Mth.Value) & "/1/" & (CB_Yr.Value)) I think the values of CB_Mth.Value and "/1/" must be switched. Can you tell me if I am right? If so, I would write a supplementary function with a regional parameter to set the date in the right sequence with the chosen region. Thank you for your help.
Thank you so very much, I really appreciate this feedback because i want to create a full training on it and I need to make changes to the code. I think you are right on this and i have to run some type of a for the regional settings. Your feedback is going to be really helpful. Perhaps you can email me if you have made any changes that work with both. This is important as I am going to be creating a full training on this add-in this week that goes deep into this date picker. I hope this helps and thanks so much.
Hi Rob, I have made a few changs on the Date Picker. Can you check this one? It is not an addin, just a macro-enabled workbook you can test out and let me know if its working in your regional. You can just select cell H5 on sheet 1 to test it out. Make sure to unblock macros after downloading by right-clicking on the file > Properties and checking 'Unblock' here is the link for the downloaded update www.dropbox.com/scl/fi/ubu1d19dpzgvjf1hejpfl/DatePicker_Add-In_test.xlsm?rlkey=xfb64d0bwmqyguf0fp33fix2i&dl=1 Feel free to email me with any feedback Randy@ExcelForFreelancers.com Thanks so much Rob
Hi and thanks very much. I am glad you liked the training. Please feel free to email me for any opportunities Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
I really like this calculate age function as an addin, however, it does not work on Mac. Could you advise what would be needed to be changed to allow the code to be written for an Excel Mac OS function?
Hi and thanks so much. I do not have a Mac to test on and I am not sure of the changes required. Can you post the issue 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.
@@ExcelForFreelancers Thanks for getting back to me! I will try to sort this out myself as this will help me in learning, however if I get stuck I will definitely post it on the forum. I will also join the forum, as I do find your videos very helpful in learning VBA.
Very informative. If I use the Calendar Date Picker Add In, it looks like it is triggered by selected any cell with a date format. Is there a way to use it and only have it appear for cells that are specified to respond with the picker. Otherwise I just edit the date normally. I have another date picker add currently but it is shape based and I can select a cell as a worksheet selection event and then the shape is opened and the picker is mapped to the selected cell to deliver the picked date. Would like similar functionality?
Hi and thanks for your comment. It may be possible but i have to figure it out. Since an addin works with every workbook you open on any date field. The idea with this date picker is that it works without you changing any code. The Shape Based date picker that I developed works with changing the code and using specific cells. So if you are ok with changing cells in the code then maybe the shape-based datepicker is good for you I hope this helps and thanks so much.
This is great, I am struggling with a getcolour function that I need in multiple WBs Function getColour (x As Range) As Interger get Colour = x.Interger.ColorIndex End Function It works if it's in a module in the individual wb but won't work as an addin? It recognises the function when typing but just get the result #NAME? Any ideas?
Hi Dino, 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 60,000 Members who would love to help you with this. Thanks so much.
@ExcelForFreelancers thanks I'm part of that group already, its kinda solved. I changed the name to "getColourAddin" or "getColourID" and they both worked perfectly even if its the US spelling "getColor" it works just not with "Colour" ? There's no debug error message etc maybe it just don't like that word/spelling
ah ok very good, yes it must have been a spelling issue. I am working on a nice update for the next training for this customizable date picker and will release it next Tuesday. Thank you for your Likes, Shares & Comments. It really helps.
Hi I have recently purchased your Excel AI tool add-in ($69.97). I have copied the file in the regular add-in folder, see it in the Add-ins windows, can select it but it does not load. I use this channel to ask for help since I already e-mailed you but did not get a reply
Hi and thanks and i am sorry to hear that and thank you for your purchase. I am not sure why you did not get a response as I respond to every single email every day. Make sure you email me here Randy@ExcelForFreelancers.com Whenever a workbook (or add-in) is downloaded from the internet, you will first want to right click, go to properties and click the 'unblock' checkbox. You can then load it normally as an add-in As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much. I also show you how to load it in your workbook here: www.excelforfreelancers.com/docs/ai-toolpack-installation-overview/ I hope this helps and thanks so much.
![How To Create Your Own ChatGPT AI Assistant Add-In For Free In Excel [+ FREE Download]](http://i.ytimg.com/vi/S17cYc6oKMw/mqdefault.jpg)
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
You have answered SO many of my questions and struggles of the past 6 months with this video. I can't thank you enough! So excited to use this long weekend to build some awesome new projects now that I can store data in my add-ins. The date picker will be really helpful too! Thank you!
That is so great to hear. I also love building add-ins and its kinda new for me too. So I will be creating more and more. Thank you for your Likes, Shares & Comments. It really helps.
I would love to have a tutorial on the date picker, so that I can be used in the worksheet and another form. I have several workbooks with forms where I’ve been trying to do just that.
Yes great thanks I am going to create that very soon. I think i will also make some nice updates to the addin as well so that it is even better than what I have shared in this training. Thank you for your Likes, Shares & Comments. It really helps.
This is amazing! Thank you so much!
For sure, you are very welcome Don and thanks so much for your kind comments and generous tips
Lot of really great info, Randy! Gave me a lot of ideas to play around with.
Great, and thanks so much Thomas. I am happy to help and share
Hi Randy, another great video.
Q: what’s the advantage of using add-ins versus saving a macro in the Personal Workbook?
Hi Ron, thanks for your comment. Add-ins are great for something you may want to run while other workbooks are open. For example I just created a Date Picker add-in which can be used as soon as a new workbook is open, which can't be done with a Personal workbook. You can see that here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html
I hope this helps and thanks so much.
Great sir
I only expect that from you.....
You are amazing
Keep uploading basic tutorials like that..
Thank you, I will for sure each Saturday. Much appreciated
Excellent video, Randy. Thanks.
Thank you so very much, I really appreciate that Russ
Great sharing, Thank you very much!
For sure, you are very welcome and I am happy to help and share
Love you videos Randy... do you have any video where we can call a command through VBA in an add-in (VBA will execute a command in the add-in rather than manually going in to Add-in and clicking on the command)
Hi and thanks for your comment. I believe I cover this in my Date Picker add-in here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html
I also have a Share & Sync add-in coming next Tuesday here: th-cam.com/video/G9VqF7yN0Oo/w-d-xo.html
I hope this helps and thanks so much.
And another great video. Thank you very much.
Thank you so very much, I really appreciate that Jan
Thank you so much for the share.
For sure, you are very welcome and I am happy to help and share
Slick stuff Randy. If you do the datepicker deep dive can you include how you might use it in a spreadsheet that is used by multiple users in one location on a shared workbook. Or did i miss it?
Hi Larry, thanks so much. I have had a few questions on the date-picker so I think I will work on it today and have it ready next week. This add-in should work well on any workbook installed on, even if it is a shared workbook. Do you foresee any conflicts that I should address during the video?
The only question is if it is on a server or onedrive that is shared with other users. Do they all have to have the blame on their desktop or under options adding you can create a directory for custom add ins and assign then. It would I guess be the same with any add in. E.g. Office manager is entering say PO and Plant manager is doing receipt of goods. Both would use date picker in same spreadsheet but 2 different machines. Make sense or am I clueless?
When using the correct Share & Sync that i share here: th-cam.com/video/f_1HsR9305I/w-d-xo.html
Each user has their own, independent, application, and only the data is shared between users. So there is no issue with each user having their own addins which do not affect one another.
Even if two users used the same exact file, such as sharing the file via a shared folder, each user would still use their own, unique add-in, and the addin would be mapped to a folder on their computers.
I hope this helps and thanks so much.
Thank you Randy for these videos and workbooks. I have been downloading the videos and using them to reinforce the teaching of the video. I have not been able to find out how to download the workbook for the first part of the video, but only the BONUS workbook. Please tell me how to get that first workbook. Thank you
Hi and thanks for your comment. The template for the first part of the video was almost nothing, not much coding and almost nothing in the workbook so i did not make it available. There was not much on it actually however you can download it from the following link:
www.dropbox.com/scl/fi/f08juc0a3ns1qgvnir7u2/Addin_Details.xlsx?rlkey=sep3r7f6rauci2clqzrfpog5n&dl=1
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks Randy - it was mostly that first page that I wanted to see more closely and clearly. Got it.😁
Ok very good, no problem at all
Waiting with a cup of tea, looking forward to this.
Great. Thanks so much. I hope you have enjoyed it
tnx Randy, great work. Question: I have the dutch version of excel and the european date = dd/mm/jj. So this datepicker doesn't work for me. What do I have to change in VBA?
HI and thanks so much. You can modify the code to recognize the date picker format however consider modifying this line code here
If IsDate(Target.Value) Or Target.NumberFormat Like "*yy*" Or Target.NumberFormat Like "*dd*" Or Target.NumberFormat Like "*mm*" Then
based on your date format
Please let me know what you found that works so i can make the updates
I hope this helps and thanks so much.
@@ExcelForFreelancers i'm sorry nothing I did works. Stuck in the code. I wait for a video around making a calender. 😏
i belive to have same problem. Finnish euorpean date = pp.kk.vv and the addin throes "type mismatch". Tried to change the line you noted, not working.
Thank you @ronge7916 and @madwelho I will be making modifications to the code and we will be going over it in detail within the next training so that it works on more regional dates. I will make updates so that it works within your region as well. I hope this helps and thanks so much.
Hi Randy, thanks for sharing all your work. You guys are the best!
I have downloaded the AddIn but it gives me an error Type Mismatch and it brings me to the Line:
“With CalendarFrm” (Object variable or With block variable not set)
Why is this error?
Hi and thanks for your comment. This could mean that the date picker will not work for your regional settings on dates.
I Have a new training with an updated date picker that may work coming this Tuesday here: th-cam.com/video/1JtbErLgOnA/w-d-xo.html
You can also test out this new Date picker here:
www.dropbox.com/scl/fi/ydvc9xgumr2wzngk0sjju/DatePicker_Add-In.xlam?rlkey=0npky72i6sdbcav8po3ip2wtl&dl=1
Please let me know if the updated one solves the issue
Hi Randy thanks for sharing
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps. Tobaye. (make sure you download the bonus. You will love it)
Randy
If the sheet is set to the default zoom of 100%, the date picker pops up as you say it will, however if the zoom is set higher or lower than the 100% it move, Up >100% and down from the 100% and it is gone from the screen, since I started writing this I have changed the format of the column and got it back onto the screen but the above still applies.
Hi Malcolm, thanks very much. You would need to adjust the points to pixels code based on the current zoom level. To extract the current zoom level you could use
ActiveWindow.Zoom
You would then need to incorporate this into the formula, and modify it until the positioning is correct.
I hope this helps and thanks so much.
@@ExcelForFreelancerscan you give me an example please
Hi and thanks. I do not have any available examples at this time.
Thanks you for this amazing tutorial!-- from your new minion, Don! :)
WOW. So amazing. Thanks so much. I can't tell you how much I appreciate that. Your kindness and generosity are incredible. Let me know if you want me to build anything and share it on TH-cam if i have not done so already
Hello Sir, Could you please share me the link of your VBA Tutorial for beginners in the comment? Thanks
Hi and thanks for you comment. I have many VBA Basic trainings. Is there a specific TH-cam one you want to see or you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
Hello Randy,
Very useful video and a magnificent add-in you offered
I live in Belgium (Western Europe) and our date notation is "dd/mm/yyyy".
I installed your add-in but it doesn't work for our date notation.
After looking into the code, I think the error happens in the SUB Build_Calendar in the following code :
If I < Weekday((CB_Mth.Value) & "/1/" & (CB_Yr.Value))
I think the values of CB_Mth.Value and "/1/" must be switched.
Can you tell me if I am right?
If so, I would write a supplementary function with a regional parameter to set the date in the right sequence
with the chosen region.
Thank you for your help.
Thank you so very much, I really appreciate this feedback because i want to create a full training on it and I need to make changes to the code. I think you are right on this and i have to run some type of a for the regional settings. Your feedback is going to be really helpful. Perhaps you can email me if you have made any changes that work with both. This is important as I am going to be creating a full training on this add-in this week that goes deep into this date picker. I hope this helps and thanks so much.
Hi Rob, I have made a few changs on the Date Picker. Can you check this one? It is not an addin, just a macro-enabled workbook you can test out and let me know if its working in your regional. You can just select cell H5 on sheet 1 to test it out.
Make sure to unblock macros after downloading by right-clicking on the file > Properties and checking 'Unblock'
here is the link for the downloaded update
www.dropbox.com/scl/fi/ubu1d19dpzgvjf1hejpfl/DatePicker_Add-In_test.xlsm?rlkey=xfb64d0bwmqyguf0fp33fix2i&dl=1
Feel free to email me with any feedback Randy@ExcelForFreelancers.com
Thanks so much Rob
Your performance is genuinely outstanding! Would you be open to discussing my work?🙂🙏
Hi and thanks very much. I am glad you liked the training. Please feel free to email me for any opportunities Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
Thank you, for this tutorials
For sure, you are very welcome and I am happy to help
I really like this calculate age function as an addin, however, it does not work on Mac. Could you advise what would be needed to be changed to allow the code to be written for an Excel Mac OS function?
Hi and thanks so much. I do not have a Mac to test on and I am not sure of the changes required. Can you post the issue 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.
@@ExcelForFreelancers Thanks for getting back to me! I will try to sort this out myself as this will help me in learning, however if I get stuck I will definitely post it on the forum. I will also join the forum, as I do find your videos very helpful in learning VBA.
Yes for sure. There is some great code for Mac's here www.macexcel.com/
I hope this helps and thanks so much.
Very informative. If I use the Calendar Date Picker Add In, it looks like it is triggered by selected any cell with a date format. Is there a way to use it and only have it appear for cells that are specified to respond with the picker. Otherwise I just edit the date normally. I have another date picker add currently but it is shape based and I can select a cell as a worksheet selection event and then the shape is opened and the picker is mapped to the selected cell to deliver the picked date. Would like similar functionality?
Hi and thanks for your comment. It may be possible but i have to figure it out. Since an addin works with every workbook you open on any date field. The idea with this date picker is that it works without you changing any code. The Shape Based date picker that I developed works with changing the code and using specific cells. So if you are ok with changing cells in the code then maybe the shape-based datepicker is good for you
I hope this helps and thanks so much.
This is great, I am struggling with a getcolour function that I need in multiple WBs
Function getColour (x As Range) As Interger
get Colour = x.Interger.ColorIndex
End Function
It works if it's in a module in the individual wb but won't work as an addin? It recognises the function when typing but just get the result #NAME?
Any ideas?
Hi Dino, 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 60,000 Members who would love to help you with this. Thanks so much.
@ExcelForFreelancers thanks I'm part of that group already, its kinda solved. I changed the name to "getColourAddin" or "getColourID" and they both worked perfectly even if its the US spelling "getColor" it works just not with "Colour" ? There's no debug error message etc maybe it just don't like that word/spelling
ah ok very good, yes it must have been a spelling issue. I am working on a nice update for the next training for this customizable date picker and will release it next Tuesday. Thank you for your Likes, Shares & Comments. It really helps.
I didn’t know that they called it an add-in.
Yes for sure. This last year I have developed a few, and will continue to develop more. I hope this helps and thanks so much.
Hi I have recently purchased your Excel AI tool add-in ($69.97). I have copied the file in the regular add-in folder, see it in the Add-ins windows, can select it but it does not load. I use this channel to ask for help since I already e-mailed you but did not get a reply
Hi and thanks and i am sorry to hear that and thank you for your purchase. I am not sure why you did not get a response as I respond to every single email every day. Make sure you email me here Randy@ExcelForFreelancers.com
Whenever a workbook (or add-in) is downloaded from the internet, you will first want to right click, go to properties and click the 'unblock' checkbox. You can then load it normally as an add-in
As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
I also show you how to load it in your workbook here: www.excelforfreelancers.com/docs/ai-toolpack-installation-overview/
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks for the suggestions randy. It is fixed now.
Ok very good I am glad you were able to get it working.