I have a custom ribbon with a button that I want to open a userform.
I used the following code:
I get an error "Runtime Error 9, Subscript out of range". When I debug, it highlights the "UserForm1.Show" line above.Please Login or Register to view this content.
If I remove the "control As IRibbonControl" and connect the sub to a button, it opens the userform as expected.
Is there some reason why it would not work from the ribbon?
Bookmarks