Pass Arguments to Function Through Ribbon

gmaxey · #5 03-14-2015, 05:04 PM

There was nothing above my post when I replied earlier. Just the thread title.

I'm assuming you have a common button OnAction macro defined in your RibbonX and a Button OnAction macro something like the following in your VBA project:

Code:

Sub ButtonOnAction(control As IRibbonControl)
Dim pCall As String
Select Case control.ID
  Case "Btn1", "Btn2", "Btn3", "Btn4" '... etc.
     modMain.DoSomethingWithThisButton control.Tag 'Use the control tag property to define a variable argument.
  Case Else
    'Do Nothing
End Select
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Pass Arguments in a Formula?	tinfanide	Excel Programming	2	10-13-2014 06:10 AM
How to Pass Document to this Sub	ilcaa72	Word VBA	1	01-28-2014 03:04 PM
How to import the customized ribbon to Word without overwriting the existing Ribbon?	SharonSh	Word VBA	0	09-26-2013 11:47 PM
How to pass parameters to a .msg file?	HereNow	Outlook	0	11-05-2012 10:38 AM
Excel 2010 Ribbon look like 2007's Ribbon	esotop	Excel	0	03-22-2011 07:05 PM