View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default passing parameters to OnAction

What version of excel. I have seen posts here that indicate support for this
has been discontinued around xl2002 or one of the last service packs in
xl2000. Post back with your experience and version if you will.

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Thank you, sir.

"Michel Pierron" wrote:

Hi Joe,
double quote and simple quote and Sub Name and 3 x double quote &

Parameter
& 3 x double quote and simple quote and double quote
Example: .OnAction = "'MySub """ & Parameter & """'"
Regards,
MP

"Joe" a écrit dans le message de
...
I am using Xl 2002. Is it possible to pass a parameter to the Sub

referenced
in the OnAction property (i.e. OnAction="processMe(Argument1)"?

TIA,
--
Joe

VBA Automation/VB/C++/Web and DB development