CODEWITHSUNDEEP
excelvbaadditionuserform
Glenn Sugana
Glenn Sugana

Reputation: 11

Creating a button on Excel Ribbon to open Userform Window

I have developed a VBA userform interface that allows the user to input values, have it calculate results, and then print them out into the worksheet. I am wondering if there is any possible way that I can have a button on the excel ribbon, say under the "Data" tab for instance, that would elicit the userform interface to open.

Currently the only way I can use the interface is by Developer>>Visual Basic>>Clicking on Userform>>F5. This also limits the userform in that it can only be used in one particular workbook as opposed to many. Or if it was somehow possible, to make it an add-in instead.

Any help is greatly appreciated!

Upvotes: 1

Views: 1454

Answers (1)

Maciej Los
Maciej Los

Reputation: 8591

The easiest way to add custom tab and/or button to Ribbon is to use Custom UI Editor Tool for MS Office Ribbon. Follow the links provided in comments to your question too. There you'll find many useful information.

Upvotes: 2

Related Questions