Pass Ribbon Button ID to Macro

[chris seiter]

I have a custom tab in 2007 that contains a drop-down menu. Each item in the
menu is different, but the macro will perform the same function with a few
differences based on which menu option is selected. How can I pass the id of
the menu item pressed to the macro so I don't have to write 7 different
macros for each? I'd like to just use a Select Case for the name and change
the items based on that.

 

[Greg Maxey]

Chris,

See if this offers any help:
http://gregmaxey.mvps.org/Ribbon_Menu_Controls.htm

 

[Greg Maxey]

Chris,

The "ID" of the menu button pressed is available in the VBA callback:

Sub ButtonOnAction(control As IRibbonControl)
'Pass the ID as an argument to a separate macro
YourMacro control.ID
End Sub

Sub YourMacro(ByRef pStr as String)
Select Case pStr
Case "Btn1"
'Do this
Case "Btn2"
'Do that
Case "Btn3"
'Do something else
End Select