VBA macros not appearing

[dnaf]

Hi!

When I try to make a new “Execute VBA macro” function in zenon 7 none of the macros are showing up under the list of options.
It does give me the full list of macros when I’m editing one of the buttons I created for my screen, so I can’t figure out why it won’t show up when I’m making a new function.

Any help is appreciated!

[markclemens]

Hi dnaf,

Thanks for your post, and welcome to the forum

The function "execute VBA macro" will only list those VBA macros that are located in e.g. "thisproject", that match the number of parameters defined at the function.

If you have a "sub test()" in "thisproject", and you don't specify any parameters at the function, this procedure should be listed when you create a new execute vba macro.

If you have a "sub test (mString as String)", and you have specified one parameter at the function, this procedure should be listed at the execute vba macro function.

VBA macros in the ModuleElement are designated to be executed on zenon element events (e.g. leftclickdown), and cannot be executed through a "execute vba macro" function.

I hope this helps
Best regards,
Mark

[dnaf]

Great, got it!
Thanks!

[Joulzer]

Hi dnaf,

Thanks for your post, and welcome to the forum

The function "execute VBA macro" will only list those VBA macros that are located in e.g. "thisproject", that match the number of parameters defined at the function.

If you have a "sub test()" in "thisproject", and you don't specify any parameters at the function, this procedure should be listed when you create a new execute vba macro.

If you have a "sub test (mString as String)", and you have specified one parameter at the function, this procedure should be listed at the execute vba macro function.

VBA macros in the ModuleElement are designated to be executed on zenon element events (e.g. leftclickdown), and cannot be executed through a "execute vba macro" function.

I hope this helps
Best regards,
Mark

Is this still working in 7.50. Because I followed the procedure but when the function is executed it is not running the sub. I put a stop in the sub but it will not break at the beginning of the sub

Should the parameter that I have input in the function have the following syntax  VARSTRINGPARAM or "VARSTRINGPARAM" (both are not working)