Excel VBA Introduction Part 33 - Creating Add Ins

By Andrew Gould

[kashifkhanspecial]

This message is for Andrew Gould, I don’t have any special word for you, that how much I thank you for your Excel VBA tutorials on YouTube, I learned a lot of watching those videos, and now I am doing job in Excel VBA with full of confidence, thank you so much for that, I have one kind request to you that, it would be great help if you would post video tutorial, for how can we create Command Bars, Menus, Sub Menus, right click menus or how can we play with menus in Excel through VBA.

Thanks Kashif

[shanta]

Very clear and useful instructions. It's of great help to me as I am learning Excel VBA. Thank you, Andrew.

[GersonCarhuapoma]

I find this really helpfull to bring up my own functions i used to save in txt files and paste whenever new workbook created. Thnk u very very much!

[krn]

Thanks Andrew. You are a great instructor.

[tajsay]

thank you so much Andrew for this video.

[jnwte]

This is great, thanks! Currently I'm using the Personal.xlsb file but I might switch to this method since you can store your code file anywhere you want in the filesystem/on network and share with others. Also I get tired of the read only prompt for Personal.xlsb when I'm working with multiple spreadsheets. Don't understand why Microsoft didn't disable it from showing for that file.

[VBAbyMBA]

amazing it solved one of my recent issue. thanks

[oleksijm]

This is excellent. Thank you so much for your work.

[o.cheolpark]

Thank you for sharing this video and this is what I looking for.

[OrangeBossa]

Thank you for the training video! So if I understand correctly, saving the LongDateFormat UDF in this example as an Excel add-in and as a module (.bas file) is very similar, the difference is that add-in is easier for the function to be used in different workbooks, while for module it must be imported each time? Thank you!

[ahmedJaber]

Thank you andrew for this
So is this better than using personal work book?
So then i could create macros and save them this way

[DBJedi]

2 questions. 1. Can the add-in need to contain Sub procedures? 2. Does if require the Public (ie Public Function or Public Sub)? Thank you.

[o.cheolpark]

Hi Andrew, can you show me how to display userforms defined add-ins

[mariomorazan]

can we make add-ins from workboook module???

[rakeshkumarmadella]

Book which I can read & learn more & more codes

[MrRossss]

Hi Andrew. Can I ask please - does it matter if the add-in is made on a 32 bit machine/version of office as to whether it will run on a 64 bit version of excel and if so would it just be a case of recreating it again on a 64 bit machine/version? Thank you

[zsoltnemeth]

Hi Andrew!
This is a great video again. Thanks a lot for it!
I have a question though: What did I wrong? I created an add-in, and installed it as You showed, and there are more buttons already on the ribbon of the functions from it. Everything okay. But! If I open the XLAM from the VB Editor, and write some new Sub routine (even if it is only simply just a range.select), it seems not being able to save it. I click on the small floppy icon, it shows, that my xlam will be saved, but if I close and re-open excel, my new routine is disappeared. :( My original 2 functions are still there, and the 3 old Sub routines too, but my new sub has vanished. How? Why?
So in general:
What are the right steps if I want to change/update an already existing XLAM with new buttons, etc?
Thanks a lot!
Zsolt

[SantoshLoka]

can we disable Vba Project Properties as well as Module..i want to make them unselect is it possible?

i Need Good Protection for my File

[edgarsan]

Thanks just a question do you know how to crack a add-ins password?

[rakeshkumarmadella]

Hello wiseowl sir.. I want to mastry in vba... How do I do it.. Please suggest any good 📖