How to Create a Custom Excel Add-in (Step-by-Step Guide)

[@CodingIsFun]

*Hope this video helps you to create your own Excel add-in!* 🚀 Here are all the relevant links: 👉GitHub Repo: github.com/Sven-Bo/excel-add-in-tutorial-template 👉Office RibbonX Editor: github.com/fernandreu/office-ribbonx-editor/releases/tag/v1.9.0 👉MyToolBelt Add-in: pythonandvba.com/mytoolbelt 👉Office imageMSO icon library: bert-toolkit.com/imagemso-list.html 👉Blog Post (XML/VBA Starter Code): bettersolutions.com/vba/ribbon/document-level-customui-editor.htm 👉Microsoft Custom UI Docs: learn.microsoft.com/en-us/openspecs/office_standards/ms-customui/d842006e-3187-4f66-a17d-0819a3cc94b5

[@JimmyBuffetParrotVomit]

Great walk through video! I've spent the afternoon installing Visual Studio and trying to figure out their IDE and how to build an Add In through the project template but this is 1000x simpler and works for sharing a few work tools with coworkers... Thanks!

[@CodingIsFun]

Glad to hear that you liked the video. Good luck with your add-in. I am sure your coworkers will love it! :) Cheers, Sven ✌️

[@ajayhuestis4981]

I've been needing to create my own ribbon add in for a while and this was super easy to follow and straight forward. Thanks!

[@CodingIsFun]

Happy to hear that you liked the video. Good luck with your add-in and happy excelling! Cheers, Sven ✌️

[@ajayhuestis4981]

On a side note. I don’t suppose you’re planning another video with how to make the custom tick marks on your add in?

[@CodingIsFun]

@@ajayhuestis4981 I am afraid you are right. I will most likely focus more on Python-related content in the future. I might only sprinkle in some VBA videos here and there.

[@servatechtips]

Wooow, it's so cool, can you another video for word Add-in?

[@CodingIsFun]

Glad you liked it and thanks for your video suggestion :)

[@Ghfcvhycvyy]

Very very good video!

[@CodingIsFun]

Thank you! :)

[@christianrauth1425]

Great that you are back 🚀 I should think of creating my own Excel Add-In 🤓

[@CodingIsFun]

Thanks, Christian! Go for it and happy coding! 🚀🤓

[@ricardo.alves.campos]

Welcome back, very nice video!

[@CodingIsFun]

Thank you, Ricardo! I appreciate all your support! 👍

[@shiazasif8058]

Welcome back

[@CodingIsFun]

Thanks! ♥

[@init_yeah]

Its been a while hope you can make even more exciting videos!

[@CodingIsFun]

Yes, I took a small break from KZbin in March as I was on vacation. But rest assured, there will be more videos coming in the future! :)

[@krishnashravan]

Very detailed video a small doubt: I'm trying to connect to the azure open ai service(instead of open ai) what changes should have to make in the code

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@PatrickAngwin]

Hey Sven, great tutorial. I've been thinking for a while now that I'd like to learn how to create an Excel add-in with a custom ribbon tab and icons, etc, to give myself easy access to macros I've developed which could be useful across different workbooks, etc. Today I followed your step-by-step guide and it all worked perfectly: I now have a personalised ribbon tab with my first custom icon to launch a little routine I wrote, plus I've taken the liberty of adding your two IFERROR tools, which no doubt will also come in handy. If you ever have the time and the inclination to do a follow-up video to explain more advanced techniques using some of the different elements you mention briefly starting at 10:43, that would be great!... But in the meantime, thanks for this excellent introductory lesson which was enough to get me up and running.

[@CodingIsFun]

Hi Patrick, Thank you so much for the positive feedback! I'm thrilled to hear you were able to create your own add-in. I've noted your suggestion regarding a follow-up video, but I can't make any promises at this moment. In the meantime, you might want to explore this wonderful playlist from a fellow KZbinr. It includes more in-depth tutorials on how to add advanced ribbon elements: kzbin.info/www/bejne/r6GsY4mOjsaLh6s&ab_channel=VBAA2Z I hope it proves helpful! Happy Coding!

[@JoeMcMullin]

Would absolutely love a tutorial on how you made the Table of Contents WITH clickable screenshots!! Genius!! I am really enjoying your Add-in "My Tool Belt" Pro version is perfect.

[@CodingIsFun]

Happy to hear you're enjoying the MyToolBelt PRO Version! Your video request is definitely noted, but creating a detailed walkthrough of the TOC feature might be a bit out of reach at the moment, since I’m currently diving deeper into Python topics. Seems to resonate better with the audience for some reason. But hey, never say never, right? Anyways, super happy to hear you liked the video and are enjoying the MyToolBelt add-in. Cheers, Sven ✌

[@JoeMcMullin]

@@CodingIsFun maybe a comment pointing towards some resources on the topic of adding linked screenshot macros??? Worth asking 😊

[@jomo.alfredo]

You are a talented teacher. Thanks so much.

[@CodingIsFun]

Glad to hear that you like my teaching style. Cheers, Sven ✌️

[@alexmorton5556]

Nice Video, very helpful. Do you know how to make a VBA addin that opens a side pane with UI elements? Like the wikipedia addin say?

[@CodingIsFun]

Thanks! You could do that with VSTO or Office.js Excel add-ins :)

[@ernestoluyov]

you can use visual studio and create VSTO addin (in VB or C#) add Pane object in your project. or create an office addin using visual studio or visual studio code.

[@balazspalinkas7848]

This is an amazing video!! Thanks so much for taking the time to explain!!

[@CodingIsFun]

Glad it was helpful! Thanks for watching! Cheers, Sven ✌️

[@chuxTube68]

I have a couple VBA functions I put together in an XLSM file and want to use it as an add-in for other sheets I create. How do I keep the XLSM from opening up when I open a file that has the add-in attached to it?

[@CodingIsFun]

Thanks for watching. Sorry, but I am not sure what you mean

[@ernestoluyov]

I understand that your macros is in the excel file (XLSM) embedded. You have to create an add-in. How you call your initial method?

[@malaychowdhury4546]

This is amezing Sir Thanks a Lot..........

[@CodingIsFun]

Glad to hear you liked it! Thank you for commenting and watching. -Sven

[@parikshitdambhare6647]

Great video. Watching from India. I m from forest department. Really very helpful video for save jungle and wildlife. But I can't find "My add in" in your website. Please guide

[@CodingIsFun]

Thanks for watching. The links, including the Excel workbook from the video, are in the description box.

[@parikshitdambhare6647]

Thank you sir for lighting speed reply ❤

[@zialielmahdy]

Thank you, that was good

[@CodingIsFun]

Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍

[@CRITCS1990]

Sri Lanka 🇱🇰 ❤

[@CodingIsFun]

😍♥

[@karthikmngowda]

Hi Sven, how to write python code in vba macro?. Not to use runpython and call py file using xlwings, want to write python code in vba just like we write in spyder, jupyter notebook or other IDEs. Is thr any dll or settings available to do so.

[@CodingIsFun]

VBA is its own scripting language associated with Microsoft Office products and does not support writing Python code within it. You can call external Python scripts via certain methods (like RunPython in xlwings), but there's no way to write Python code directly in VBA as if it were a Python IDE like Spyder or Jupyter Notebook.

[@karthikmngowda]

@@CodingIsFunsure got it and thank u for ur reply

[@masotolazarus1971]

Hi Sven, Great Video thanks for sharing. it would be great if Excel Lambdas could be turned to Add-ins any idea if this is possible? many thanks

[@CodingIsFun]

Hi there! Thanks for watching. Accessing lambda functions directly in VBA isn't possible, but there's a workaround you might find useful. You can actually create your own functions within VBA. These functions become available to anyone with your add-in installed. For example, I recently developed an "AI Formula" that connects to the OpenAI API. Check out this video for a demo: kzbin.info/www/bejne/o2echph3Z5ydfNE Also, if you're interested in creating your own user-defined functions, here's a guide that could help: trumpexcel.com/user-defined-function-vba/ Hope this helps! Happy Coding! Cheers, Sven ✌️

[@전승환-h4b]

This is really good. Thanks! Can I use this to add into Powerpooint and Outlook?

[@CodingIsFun]

You can also crete PowerPoint and Outlook add-ins. The process is similar, but not the same. For you reference: stackoverflow.com/a/37548779 I hope it helps! Happy Coding! Cheers, Sven ✌️

[@dirtydevil81]

Top Video! Thank you! I wished, somebody would do similar videos, e.g. in that quality, for OpenSource Software like Libreoffice Writer or Calc. Would you mind, stepping into these ? ;)

[@CodingIsFun]

Thank you for taking the time to watch the video and for your kind words! I'm glad to hear that you found it helpful. I appreciate your suggestion, but unfortunately, I do not have much experience using those programs. Throughout my career as a data analyst, I have primarily used Excel. 😅

[@robertcenusa8636]

As always, 10/10 video 👏 Though, I need to ask: would you consider making an advanced version like, hiding all other tabs and locking for the user the possibility to show them again or to see the vba codes from behind?

[@CodingIsFun]

Thank you for watching and for your feedback. I appreciate your suggestions for an advanced version of the tutorial. However, at this point, I'm not planning to create one. That being said, I never say never, but I can't make any promises 😅. Thanks again for your support.

[@sujungpark5764]

Hi Sven :) did you have nice time in Sri Lanka ? And this video is really cool !

[@CodingIsFun]

Hey Sujung! Thanks for watching. So happy you liked the video! Oh, and Sri Lanka was a blast, had an awesome time there! 🎉

[@finessejones3109]

New sub: Thank you for your video this is exactly what I been looking for. I followed your instructions several times and I keep bringing back a error code stating my api key is invalid but I generate 3 different ones and still same error

[@CodingIsFun]

Thanks for watching. Please have a look at the following possible solution: github.com/Sven-Bo/Integrate-ChatGPT-in-Excel-using-VBA#common-issues-and-solutions

[@haninawaya9967]

That is awesome 🎉❤

[@CodingIsFun]

First comment! :) Thank you! Happy Developing! 🤓

[@haninawaya9967]

@@CodingIsFun I always wait for your great videos 📷

[@CodingIsFun]

@@haninawaya9967 Thanks for your support! 🙏

[@mhrunakshaykarnikaavyukta6034]

Can you guide me how can I publish my own add-in file to the excel add-in store so that other users able to install it in their system without my manual intervention.

[@CodingIsFun]

Thanks for watching. That is only possible for Office JS Add-ins. Please refer to the office Microsoft docs: learn.microsoft.com/en-us/office/dev/add-ins/publish/publish-office-add-ins-to-appsource Happy Coding! Cheers, Sven ✌️

[@vinodganger4038]

Thanks for giving link these will help to to study more advance way

[@CodingIsFun]

An absolute pleasure, very happy to hear that you found it useful! Cheers, Sven ✌️

[@SaifulBappy]

Great Helpfull

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

[@ТарасСак-ж8ж]

THANK YOU!

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️

[@전승환-h4b]

How can I fix the error "End of Central Directory record could not be found" when I open the xlsm in the office ribbonX editor?

[@전승환-h4b]

It was due to security program. Thanks!

[@CodingIsFun]

Glad you solved it! Cheers, Sven ✌️

[@barcode6495]

Good morning. Great videos. Very knowledgeable person and professional. I was wondering if you could post a video on pivot tables using python. Thank you!😊w

[@CodingIsFun]

Thanks for the kind words and your video suggestion! :)

[@konradg1543]

Nice! Where are you creating these graphics/animations, like in 0:14? You download it, or making urself?

[@CodingIsFun]

Thanks for watching. That is a lottie animation: lottiefiles.com/

[@mhrunakshaykarnikaavyukta6034]

Can we make a Installer software like a executable file which after installing it should automatically add my custom Add-in file in their system in excel. Please guide me how to do this task.

[@CodingIsFun]

Thanks for watching. Have a look at the following article: jkp-ads.com/articles/excel-addin-installer.asp I hope it helps! Happy Coding! Cheers, Sven ✌️

[@danesvarneelamagam8941]

How do we sell the add-in we create?

[@CodingIsFun]

Thanks for watching. That is a broad question and hard to answer. You could list it on Gumroad and sell it there, just as one example.

[@rahuldev7779]

Very nice

[@CodingIsFun]

Thanks!

[@ClaireBoitet]

How do you install RibbonX on a Mac?

[@CodingIsFun]

Thanks for watching. I think, it only works on Windows - sorry!

[@kit-kit-kittty2911]

very nice

[@CodingIsFun]

Thanks! 👍

[@dasolxandzo3152]

Sory, but when I add my add-in into Excel (like in last video part), my add-in doesn't show on top panel. How I can fix this problem?

[@CodingIsFun]

Thanks for watching. Hard to tell from a distance

[@NuaDeys]

Can I do this on a Mac? I figured not but wondering if anybody has tried?

[@CodingIsFun]

Thanks for watching. This solution does only work on Windows. Cheers, Sven ✌️

[@michaeljarcher]

How about updating the ChatGPT for version 4, as the API have been updated. And you code will be depreaceated by 2024, a very nice bit of code I must add. Even Chatgpt itself was unable to offer this function! :-)

[@CodingIsFun]

Thanks for watching. The code is already updated and I even created a video about it. Here you are ;) kzbin.info/www/bejne/aYucZ6yCoamco5Isi=l9k-1ftoQLedjpH4

[@michaeljarcher]

@@CodingIsFun Deserves a new subscriber, great job.

[@CodingIsFun]

Welcome aboard! 🎉

[@751saksham5]

Made an add in thanks but one major drawback of this is u don't have undo feature for the task u perform through this VBA add in and didn't find anything useful on internet too

[@CodingIsFun]

Thanks for watching. Perhaps the following video/approach might help you: kzbin.info/www/bejne/gaK6fZl5qc6HgcUsi=3MEA1KoreyfcnYnz Happy Coding! Cheers, Sven ✌️

[@danesvarneelamagam8941]

Will I be able to create an add in for this ? kzbin.info/www/bejne/jIjUZpdtn5ujpqs

[@CodingIsFun]

Try it out! :)

[@danesvarneelamagam8941]

​@@CodingIsFun One thing I need to mention I got an error "Wrong number of arguments or invalid property assignment", after alot of searching I found that I needed to put "control As IRibbonControl" into the macro Sub MacroName(control As IRibbonControl)

[@CodingIsFun]

@@danesvarneelamagam8941 Yes, that is exactly what I have shown at the 05:00 min mark 😉

[@danesvarneelamagam8941]

​@@CodingIsFun Ohh, apologies

[@danesvarneelamagam8941]

@@CodingIsFun Ohh, apologies

[@Nilmoy]

that strong german accent is quite awkward to listen to.

[@CodingIsFun]

Well, every office superhero needs their unique trait! Mine just happens to be a strong German accent. 🇩🇪💪

[@JoeMcMullin]

Your English is perfect! Better than my German which is NON existent. Keep up the amazing work and the passing of knowledge. The pace of your instruction is spot on and the level of information you provide is great. Thank you!!! @@CodingIsFun

[@CodingIsFun]

@@JoeMcMullin Thanks for the kind words! I really appreciate it! 🙏👍

[@BOUTAMINEOmar]

i followed you step by step but when i get excut the file excel macro after changing on office !ribbonX Editor it sais the next '' Sorry, we couldn't find C....................xlsm. it is possible it was moved, renamed or deleted? '' what's the probleme PM: in the video, it's 07:24 exactly

[@CodingIsFun]

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

[@BOUTAMINEOmar]

@@CodingIsFun can you help me? maybe by using the app AnyDesk ?? please