J
Jay
Is it possible to pass a parameter to a macro in a right-click pop-up
menu button click?
commandbarbutton.onAction..
For instance..
Dim ct3_PopUp as CommandBarButton
Dim parameter as string, tmp as string, tmp1 as string
With ct3_PopUp
.caption = ...
tmp = "(" & parameter & ")"
tmp1 = "macro1" & tmp
.OnAction = tmp1
End With
Public Sub macro1(desc as string)
MsgBox desc
End Sub
menu button click?
commandbarbutton.onAction..
For instance..
Dim ct3_PopUp as CommandBarButton
Dim parameter as string, tmp as string, tmp1 as string
With ct3_PopUp
.caption = ...
tmp = "(" & parameter & ")"
tmp1 = "macro1" & tmp
.OnAction = tmp1
End With
Public Sub macro1(desc as string)
MsgBox desc
End Sub