View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do you add arguments to an OnAction event?

Note that this undocumented feature appears to not be supported in xl2002.
I believe it may have problems in the latest service release of xl2000 as
well. At least that is what I recall has been reported here.

--
Regards,
Tom Ogilvy

"Tim Zych" wrote in message
...
.OnAction = "'DoThis ""TestString""'"

"Jason" wrote in message
...
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