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