Showing results 1 to 5 of 5

Thread: VBA macros not appearing!!!

  1. #1
    Join Date

    Default VBA macros not appearing!!!


    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!!
    Last edited by Justsmile212 : 5th September 2019 at 20:35

  2. #2

    Default Re: VBA macros not appearing!!!

    Hi justsmile212,

    The VBA code that you want to execute through a function, needs to be placed directly in "thisProject" section. When you want to pass parameters into the macro at the function, the number of parameters defined at the function must match the parameters of the macro.

    VBA macros you see at the button are located in the moduleElement section and are based of events triggered by the button.

    Best regards,

  3. #3
    Join Date

    Default Re: VBA macros not appearing!!!

    Even I am having a similar kind of issue, please can anyone help me resolve the problem I am very frustrated now as I am not able to find the solution on the internet.

    Thank in advance, Regards
    9AppsVidmate APK
    Last edited by smithclarkson01 : 17th September 2019 at 20:40

  4. #4
    Join Date

    Default AW: VBA macros not appearing!!!

    Are the macros declared as public? You can only trigger VBA macros via function that are declared as Public Sub ...

  5. #5
    Join Date

    Default Re: VBA macros not appearing!!!

    Macros that take arguments are not visible in the macro box because there is no point in having them there. If they need arguments to run, they cannot be run from the macro box because there is no way to supply an argument to the macro in question.

Similar Threads

  1. VBA macros not appearing!!!!
    By Justsmile212 in forum VBA
    Replies: 0
    Last Post: 3rd September 2019, 13:26
  2. Replies: 5
    Last Post: 12th September 2017, 13:35
  3. VBA macros not appearing
    By dnaf in forum VBA
    Replies: 3
    Last Post: 6th April 2017, 08:29
  4. Replies: 1
    Last Post: 1st September 2014, 07:29
  5. My workspace Macros?
    By softart2 in forum VSTA
    Replies: 4
    Last Post: 27th December 2010, 00:58

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts