Making an Excel Ribbon App | VBA
HTML-код
- Опубликовано: 20 ноя 2020
- Link to the all the code in this video:
github.com/maxwelldemaio/demo...
Example of a finished Excel ribbon application:
github.com/maxwelldemaio/vb-add
My links:
Website - maxwelldemaio.github.io/
Twitter - / maxwelldemaio
GitHub - github.com/maxwelldemaio
LinkedIn - / maxwell-demaio 
Наука
Thanks I just got my first VBA job thanks to this!!!
What's the job description, what does it entail?
Well articulated and easy to follow. Thank you sir.
This really helped me, thank you
Update: Hey everyone! With MS 365, in order to customize the ribbon you can actually right click anywhere in a ribbon tab and click "Customize the Ribbon."
Also, while in "Customize the Ribbon" you can export your ribbon as a "exportedUI" file so you can re-import it later on or share with others to import. Keep in mind, the ribbon file will have the hard coded file paths where your functions live. This means, if you wanted to share your ribbon application you should share the "xla" file and not the ribbon file since the filepath of the functions will be specific to your machine. However, if you're in a business setting with a shared drive, if everyone has access to the folder where the functions live you will be A-Okay to share the "exportedUI" file.
How do I add/link the custom ribbon settings inside the xla file in a global manner, as if its built into the xla file, not referencing it locally or by having to import those settings separately? I want to be able to share my add-in file to a coworker with the custom ribbon and when they enable it in their add-ins, the custom ribbon will appear automatically, as if its a part of the add-in itself. Thank you
@@tylerharper819I was also hoping to do this, any idea how?
I wanted to make the Macro (Excel Add-In) a part of the customized ribbon exactly following the steps suggested by you. Despite that I have loaded the .xlam file, I am unable to find it listed under the Customize the Ribbon >> Choose Command from >> macros. I have tried so many things but not worthy. Please help to resolve.
This is a really nice and easy to follow video, it works wonderfully in Excel.
Unfortunately I wanted to use it in PowerPoint. You can do all the steps, but when you open the module from ppa/ppam (which is similar to xla) file it doesn't get loaded into the modules.
Does anyone have any idea how to solve this issue?
Thank you in advance!
Great work! I have been looking for this for a long time. Thanks. is it possible to use this add-in on different computers?
If yes, could you please share the steps or share a video of that too.
Hey! Yes you can use it on different computers. You could move the xla file across devices as needed 😁 Basically once the file has been moved, I'd repeat the steps shown here to get it to work!
@@maxwelldemaio Thanks, it was very helpful.
Is there a way to display a "ribbon app" only for specific workbook? I want to have certain macros that are only related for specific project.
Good question, that one I'm not sure of. However, what I think would be better is if you only want certain subroutines for a workbook, you should save it as a .XLSM file (macro-enabled). This way you can go into the coding environment, code your subroutines, and actually keep them saved for the next time you open the workbook!
Do yo know of any tools that help you design a ribbon visually? I can create buttons, but it would be nice to do more advanced controls like dropdowns, checkboxes, etc while also picking icons visually.
Hi, Tim! To my knowledge, I know you change change the icons of your subroutines by going to the "Customize the Ribbon" setting.
As far as drop downs go, that would actually be a type of form the user would interact with. What I've done in the past is displaying a Userform to the user to interact and upon submission the subroutine will execute with the selected parameters!
If you'd like an example of capturing user input, checkout my VBA ribbon application I created called "vb-add" and particularly the subroutine called "rowSpecifyClean" in "Module1.bas" here: github.com/maxwelldemaio/vb-add
@@maxwelldemaio Thank you so much. I appreciate it.
I have created an excel add-in and I want to use it on other PC too. How can I keep the same UI installed on other PC while adding my add-in?
To my knowledge there isn't a way to do so. You can export your ribbon from the PC that has the add-in. However, within that exported file will be hardcoded filepaths to the Macros on that PC (you can check by opening it in a text-editor). You can import the exportedUI file to your new PC, but none of the buttons will work because they will be pointing to incorrect filepaths.
You can always move your macros onto the new PC, and just take a little time to remake the ribbon.
He Max, thank you for this video.
I'm trying to make a Macro on Ribbon that hides certain rows. As a "regular" button on the excel it works, but when I try doing it on the Ribbon it does not work. Any advice or would you be keen to make a video about it?
Hey! Without looking at the code for the Macro I'm not sure what the issue would be. But, if you have it working as a "regular" button that points to your VBA code that's a great start.
My thought is to make sure that the button on the Ribbon properly points to the VBA subroutine you are trying to execute. I'd give it a shot with a couple smaller examples that maybe just change the color of a cell to make sure your Ribbon works properly 🤔 It's been a while since I've done VBA but hope this helps.
love you bro just save my work hahahaha
Hey Max, Your video is supposed to explain how to customise the ribbon and assign new menu items to a code like a macro or something. But then you spend most of your video explaining your sub routines which is not the purpose ... What be great to focus on the subject, kr
Hey there, I did explain how to make an Excel ribbon application. The options link to sub-routines which you can customize for yourself. If you didn't enjoy the video, feel free to find a different one on RUclips.
@@maxwelldemaioIgnore this guy brother. I love your content. Btw, I know the answer to this is no but is there a git that can help me do this for Mac machines? Thanks
@@theexcelproject6973 When you say Git do you mean a GitHub project? If so, I do have an open-source repository with a bunch of useful macros I have programmed: github.com/maxdemaio/vb-add