View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_5_] Tim Zych[_5_] is offline
external usenet poster
 
Posts: 6
Default How do you add arguments to an OnAction event?

Didn't know that. Thanks for the update.

-----Original Message-----
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






.