VSTO e06 - How to create Excel Add-in using VSTO / VB.NET

In this dedicated simplified series on VSTO, you'll learn how to build Professional Solutions for Office Applications. Be sure to subscribe, Like, and Comment. 🙏Thanks for watching.

You can now support by buying any of the Projects or Source Code.

📌What to watch next:

#VbaA2z

[holieh]

Thanks for making more VSTO videos. Have been waiting for it. Thanks a lot. Excellent tutorial

[scotolivera]

Thank you sir, This VSTO Tutorial is unique, hope you keep adding to it more and more, very helpful. Thanks again

[paulhughes]

Very nice work... thanks for sharing your wisdom!

[GIG-ATT-ATT-GIG]

Thanks sir. Your tutorials are really helpful.

[zurak]

Thanks for sharing this. Currently looking into VSTO AddIns with regards to malware detection, as they bear the potential to be the successor to macro malware in MS Office.

[nori]

Happy to have found your channel today. Some cool contents you got there. Will check back for more later. Keep going.

[DrPPrabu]

Thank u so much sir... I am beginner to vsto but find your tutorial very informative ... Please add more and more like listbox and listview controls to your project...

[sunil]

Hello Pamai, your videos are amazing. keep it going.

[jonathanbrotto]

Great videos but any on conditional formatting?

[bnancy]

Thank you so much.
Can you please make a another Real-Life project video like you did for Workbook customization? It'd be great and helpful to beginners like me.

[kenstarr]

Subscribed and following, please add more videos.

[nikt]

brilliant! I assume I can do the same in c#

[cdptj]

Hi, I create CustomTaskPane same way as you in video, but if I press button to show it multiple times, it creates one another CustomTaskPane for each click. How can I prevent this or how can I create New CustomTaskPane after excel starts and on button click only change its visibility?

[excelforcivilengineers]

Please create a video on how to create Excel UDF using visual basic in Visual Studio.

[levelupexcelskill]

Tons of tanks....Could you please make video to extract dirty data from Notepad to is humble request....please make a project like this....

[dvof]

Loving the vids :)

What is the difference between creating an Excel AddIn the way you have described and using ExcelDNA?

Also, can you hide/Un-hide elements on a ribbon depending on say user name?

Thank you.

Hello, thank you for sharing.
1-I created Exceladdin 1.sln with Visual studio 2019 and I know how to add a tab to the excel program on my computer.
2- I created Setup (two files named setup.exe and Setup.msi)
3- I copied these files to another computer and installed them. All files are output to a folder. (ExcelAddIn1.vsto and many dll files)
The problem is: the plugin is not available in excel. Can you share a document that tells me about setup from start to finish? Thank you so much.

[scotolivera]

hello sir, how can i create a keyboard shortcut with vsto add in like ctr+ enter ?

[TheJLMDT]

When using VBA in an add-in, can you still use the UNDO button? Macros usually don't allow an undo

[jonathancollins]

after I am done creating my addin how to I add it to excel or do I have to run it in visual studio every time? I want to compile it and make it a permanent addon for my excel.