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