0

Is it possible to take a pre-existing button from the ribbon, Shape Fill from the Shape Styles category for example, and display it in a VBA userform?

My add-in manages a large number of shapes, and I would like to allow the user to style those shapes based on the category that they are in in the add-in.

I have read that a color dialog does not exist for us to use in VBA, so I'm trying to think of a way to work around that. Recreating all of the fill, outline, and effects menus seems like too much, there has to be a better way.

Mutex
  • 109
  • 1
  • 4

1 Answers1

1

No, built-in ribbon controls can be used on the ribbon only. As a workaround you may consider using any ActiveX custom controls on your form.

Also you may consider creating a custom UI on the ribbon. In that case you will be able to add built-in ribbon controls to your own tab by specifying its idMso value. The full list of control IDs can be found in the following documents:

Read more about the Fluent UI (aka Ribbon UI) in the following series of articles:

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45