Reputation: 5831
I am new in excel vb.net programming. I am building a excel add-in like the image attached. I have searched but did not find a way to create its UI like the attached image. Please let me know if its possible or not, if yes, please provide me the links.
Thank you so much
Upvotes: 0
Views: 137
Reputation: 606
You can create a new tab on your ribbon as Ahmad has mentioned. You can then add buttons to your new ribbon tab and have them execute macros that you have written. For example, if while working in Excel, you have to highlight cells often with yellow, you can write a macro in your personal workbook then have a button in your new tab execute that macro.
Upvotes: -1
Reputation: 12737
You can easily add your own buttons, graphics to Excel or any Office product (Word/Power Point/Excel/ etc) by simply right clicking the ribbon area, then choosing [Customize the Ribbon].
In the next window, if you want your buttons to be displayed on their own Ribbon, create a new Ribbon.
Add as many buttons as you want, and you can separate them if you like.
You can read more about Customizing Ribbons in Office products here.
Upvotes: 2