How To Create Your First Excel Add-in + FREE BONUS

Поділитися
Вставка
  • Опубліковано 4 гру 2024

КОМЕНТАРІ • 72

  • @ExcelForFreelancers
    @ExcelForFreelancers  4 години тому

    ⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

  • @BobMuntis
    @BobMuntis 6 місяців тому +3

    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!

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 місяців тому

      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.

  • @donniemcgee7523
    @donniemcgee7523 2 місяці тому +1

    Thanks you for this amazing tutorial!-- from your new minion, Don! :)

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 місяці тому

      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 UA-cam if i have not done so already

  • @RonDavidowicz
    @RonDavidowicz 6 місяців тому +1

    Hi Randy, another great video.
    Q: what’s the advantage of using add-ins versus saving a macro in the Personal Workbook?

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 місяців тому

      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: ua-cam.com/video/1JtbErLgOnA/v-deo.html
      I hope this helps and thanks so much.

  • @donniemcgee7523
    @donniemcgee7523 2 місяці тому +1

    This is amazing! Thank you so much!

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 місяці тому

      For sure, you are very welcome Don and thanks so much for your kind comments and generous tips

  • @Skylineview713
    @Skylineview713 7 місяців тому +2

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

  • @leohkhung
    @leohkhung 7 місяців тому +1

    Great sharing, Thank you very much!

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      For sure, you are very welcome and I am happy to help and share

  • @taimoorkhan8203
    @taimoorkhan8203 6 місяців тому +1

    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)

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 місяців тому +1

      Hi and thanks for your comment. I believe I cover this in my Date Picker add-in here: ua-cam.com/video/1JtbErLgOnA/v-deo.html
      I also have a Share & Sync add-in coming next Tuesday here: ua-cam.com/video/G9VqF7yN0Oo/v-deo.html
      I hope this helps and thanks so much.

  • @ThomasGoeson
    @ThomasGoeson 7 місяців тому +1

    Lot of really great info, Randy! Gave me a lot of ideas to play around with.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      Great, and thanks so much Thomas. I am happy to help and share

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 7 місяців тому +1

    Thank you so much for the share.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      For sure, you are very welcome and I am happy to help and share

  • @JanBolhuis
    @JanBolhuis 7 місяців тому +1

    And another great video. Thank you very much.

  • @RussCrowley
    @RussCrowley 7 місяців тому +1

    Excellent video, Randy. Thanks.

  • @hcr2artgallery79
    @hcr2artgallery79 7 місяців тому +1

    Waiting with a cup of tea, looking forward to this.

  • @MikeLainhart
    @MikeLainhart 7 місяців тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

    • @MikeLainhart
      @MikeLainhart 7 місяців тому +1

      @@ExcelForFreelancers Thanks Randy - it was mostly that first page that I wanted to see more closely and clearly. Got it.😁

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      Ok very good, no problem at all

  • @muhammadkausar2842
    @muhammadkausar2842 7 місяців тому +1

    Great sir
    I only expect that from you.....
    You are amazing
    Keep uploading basic tutorials like that..

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      Thank you, I will for sure each Saturday. Much appreciated

  • @tobayekaina8610
    @tobayekaina8610 7 місяців тому +1

    Hi Randy thanks for sharing

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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)

  • @malcolmsokol4294
    @malcolmsokol4294 7 місяців тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

  • @rgsentertainment9869
    @rgsentertainment9869 6 місяців тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 місяців тому +1

      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: ua-cam.com/video/1JtbErLgOnA/v-deo.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

  • @malcolmt3125
    @malcolmt3125 4 місяці тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 місяці тому

      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.

    • @malcolmt3125
      @malcolmt3125 4 місяці тому +1

      @@ExcelForFreelancerscan you give me an example please

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 місяці тому

      Hi and thanks. I do not have any available examples at this time.

  • @larryduffie1617
    @larryduffie1617 7 місяців тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      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?

    • @larryduffie1617
      @larryduffie1617 7 місяців тому +1

      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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      When using the correct Share & Sync that i share here: ua-cam.com/video/f_1HsR9305I/v-deo.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.

  • @dream_merchant_4276
    @dream_merchant_4276 7 місяців тому +1

    Hello Sir, Could you please share me the link of your VBA Tutorial for beginners in the comment? Thanks

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      Hi and thanks for you comment. I have many VBA Basic trainings. Is there a specific UA-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

  • @robbe58
    @robbe58 7 місяців тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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

  • @ronge7916
    @ronge7916 7 місяців тому +2

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

    • @ronge7916
      @ronge7916 7 місяців тому

      @@ExcelForFreelancers i'm sorry nothing I did works. Stuck in the code. I wait for a video around making a calender. 😏

    • @madwelho
      @madwelho 7 місяців тому +1

      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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      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.

  • @009hjs
    @009hjs 7 місяців тому

    Thank you, for this tutorials

  • @DinoDelight
    @DinoDelight 7 місяців тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      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.

    • @DinoDelight
      @DinoDelight 7 місяців тому

      @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

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      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.

  • @ExcelExplorers786
    @ExcelExplorers786 7 місяців тому +1

    Your performance is genuinely outstanding! Would you be open to discussing my work?🙂🙏

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому

      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.

  • @joemanflyer2001
    @joemanflyer2001 4 місяці тому +1

    I didn’t know that they called it an add-in.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 місяці тому

      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.

  • @vancampe
    @vancampe 7 місяців тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +1

      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.

    • @vancampe
      @vancampe 7 місяців тому +2

      @@ExcelForFreelancers thanks for the suggestions randy. It is fixed now.

    • @ExcelForFreelancers
      @ExcelForFreelancers  7 місяців тому +2

      Ok very good I am glad you were able to get it working.