Hi Jason,

Yes, you can do this. You can add the string to the Parameter property of
the CommandBarButton. Then, in your subroutine specified by the OnAction
property, you can check the Parameter property of the "clicked" button with
Application.CommandBars.ActionControl.Parameter.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Jason wrote:
I'd like to add an argument to an Onaction sub, which is
associated with a button? Can I?

Sub DoThis(strArg as String)
....
End Sub

Dim b as CommandBarButton
b.OnAction ="DoThis" *** THEN WHAT ***


Thanks