Passing several parameters to OnAction property.

[LABKHAND]

Hi All,

I am trying to pass three parameters to the OnAction property of a menu
Control object. What is the syntax for passing these parameters as part of
the macro name?

I currently have:

With .Controls(Caption)
.OnAction = sMacroName
.Parameter = sParameter
.BeginGroup = bFlagDivider
.Enabled = sFlagEnabled
End with

I have tried the syntax " ' MACRO NAME ""p1string"", 2, ""p2string"" ' "
which is not working and i get a syntax error that the maco does not exist.

Please help.

 

[ProfessionalExcel.com]

Going purely on the syntax you noted, try removing the spaces:

..onAction = "'MACRONAME ""p1string"", 2, ""p2string""'"

--
Please rate this post if it answers your question.

Thanks,

Chris
http://www.ProfessionalExcel.com