*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
6 ай бұрын
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
6 ай бұрын
Glad to hear that you liked the video. Good luck with your add-in. I am sure your coworkers will love it! :) Cheers, Sven ✌️
@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! 🚀🤓
@ajayhuestis4981
6 ай бұрын
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
6 ай бұрын
Happy to hear that you liked the video. Good luck with your add-in and happy excelling! Cheers, Sven ✌️
@ajayhuestis4981
6 ай бұрын
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
6 ай бұрын
@@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.
@jomo.alfredo
Ай бұрын
You are a talented teacher. Thanks so much.
@CodingIsFun
Ай бұрын
Glad to hear that you like my teaching style. Cheers, Sven ✌️
@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 :)
@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 ✌️
@PatrickAngwin
10 ай бұрын
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
10 ай бұрын
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 KZitemr. It includes more in-depth tutorials on how to add advanced ribbon elements: kzitem.info/news/bejne/2qZ_mIqOkpOJhH4&ab_channel=VBAA2Z I hope it proves helpful! Happy Coding!
@parikshitdambhare6647
8 ай бұрын
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
8 ай бұрын
Thanks for watching. The links, including the Excel workbook from the video, are in the description box.
@parikshitdambhare6647
8 ай бұрын
Thank you sir for lighting speed reply ❤
@init_yeah
Жыл бұрын
Its been a while hope you can make even more exciting videos!
@CodingIsFun
Жыл бұрын
Yes, I took a small break from KZitem in March as I was on vacation. But rest assured, there will be more videos coming in the future! :)
@Ghfcvhycvyy
9 ай бұрын
Very very good video!
@CodingIsFun
9 ай бұрын
Thank you! :)
@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.
@JoeMcMullin
6 ай бұрын
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
6 ай бұрын
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
6 ай бұрын
@@CodingIsFun maybe a comment pointing towards some resources on the topic of adding linked screenshot macros??? Worth asking 😊
@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
Жыл бұрын
😍♥
@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
@vinodganger4038
3 ай бұрын
Thanks for giving link these will help to to study more advance way
@CodingIsFun
3 ай бұрын
An absolute pleasure, very happy to hear that you found it useful! 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. 😅
@shiazasif8058
Жыл бұрын
Welcome back
@CodingIsFun
Жыл бұрын
Thanks! ♥
@user-xp1ge5bf4h
2 ай бұрын
This is really good. Thanks! Can I use this to add into Powerpooint and Outlook?
@CodingIsFun
2 ай бұрын
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 ✌️
@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
10 ай бұрын
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.
@ricardo.alves.campos
Жыл бұрын
Welcome back, very nice video!
@CodingIsFun
Жыл бұрын
Thank you, Ricardo! I appreciate all your support! 👍
@krishnashravan
11 ай бұрын
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
11 ай бұрын
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!
@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/
@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! :)
@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!
@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! 🙏
@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! 🎉
@masotolazarus1971
2 ай бұрын
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
2 ай бұрын
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: kzitem.info/news/bejne/zmxvu5l3a2mbeaQ 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 ✌️
@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
10 ай бұрын
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?
@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
@user-qy7ss1qr4k
6 ай бұрын
THANK YOU!
@CodingIsFun
6 ай бұрын
My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️
@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 ✌️
@kit-kit-kittty2911
6 ай бұрын
very nice
@CodingIsFun
6 ай бұрын
Thanks! 👍
@rahuldev7779
10 ай бұрын
Very nice
@CodingIsFun
10 ай бұрын
Thanks!
@mhrunakshaykarnikaavyukta6034
6 ай бұрын
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
5 ай бұрын
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 ✌️
@user-xp1ge5bf4h
2 ай бұрын
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?
@user-xp1ge5bf4h
2 ай бұрын
It was due to security program. Thanks!
@CodingIsFun
2 ай бұрын
Glad you solved it! Cheers, Sven ✌️
@dasolxandzo3152
7 ай бұрын
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
7 ай бұрын
Thanks for watching. Hard to tell from a distance
@751saksham5
5 ай бұрын
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
5 ай бұрын
Thanks for watching. Perhaps the following video/approach might help you: kzitem.info/news/bejne/rKeNspp5rZuFfpgsi=3MEA1KoreyfcnYnz Happy Coding! Cheers, Sven ✌️
@danesvarneelamagam8941
10 ай бұрын
How do we sell the add-in we create?
@CodingIsFun
10 ай бұрын
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.
@NuaDeys
4 ай бұрын
Can I do this on a Mac? I figured not but wondering if anybody has tried?
@CodingIsFun
4 ай бұрын
Thanks for watching. This solution does only work on Windows. Cheers, Sven ✌️
@user-ur1bs2mq6x
Жыл бұрын
How do you install RibbonX on a Mac?
@CodingIsFun
Жыл бұрын
Thanks for watching. I think, it only works on Windows - sorry!
@michaeljarcher
9 ай бұрын
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
9 ай бұрын
Thanks for watching. The code is already updated and I even created a video about it. Here you are ;) kzitem.info/news/bejne/lJBvnK2CpXaaoGUsi=l9k-1ftoQLedjpH4
@michaeljarcher
9 ай бұрын
@@CodingIsFun Deserves a new subscriber, great job.
@CodingIsFun
9 ай бұрын
Welcome aboard! 🎉
@danesvarneelamagam8941
10 ай бұрын
Will I be able to create an add in for this ? kzitem.info/news/bejne/t42nm5hto2iho34
@CodingIsFun
10 ай бұрын
Try it out! :)
@danesvarneelamagam8941
10 ай бұрын
@@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
10 ай бұрын
@@danesvarneelamagam8941 Yes, that is exactly what I have shown at the 05:00 min mark 😉
@danesvarneelamagam8941
10 ай бұрын
@@CodingIsFun Ohh, apologies
@danesvarneelamagam8941
10 ай бұрын
@@CodingIsFun Ohh, apologies
@Nilmoy
10 ай бұрын
that strong german accent is quite awkward to listen to.
@CodingIsFun
10 ай бұрын
Well, every office superhero needs their unique trait! Mine just happens to be a strong German accent. 🇩🇪💪
@JoeMcMullin
6 ай бұрын
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
6 ай бұрын
@@JoeMcMullin Thanks for the kind words! I really appreciate it! 🙏👍
@user-vq5vb6ww4z
Жыл бұрын
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.
@user-vq5vb6ww4z
Жыл бұрын
@@CodingIsFun can you help me? maybe by using the app AnyDesk ?? please
Пікірлер: 113