Controls OnAction Fails When Saved As Add-in .xla

  • Hi, i wrote some modules and all of them work without error.
    If i saved this fail in .xla format then checkboxes and combos onaction method didn't work . Do you know why?
    Why addin differ from normal excel macros?


    I will add checkboxes automatically and those would activate some procedures with argument.



    and code of dropdowns:



    i'm using excel2003 and xp.

  • Re: Controls OnAction Fails When Saved As Add-in .xla


    First chech that you cheked all the nessecary refrences in the vba window.


    could you please emial me a copy of your WB to work it out

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

  • Re: Controls OnAction Fails When Saved As Add-in .xla


    Problem can't be in references.
    Because all buttons work fine, but dropdowns and checkboxes onaction doesn't work.

  • Re: Controls OnAction Fails When Saved As Add-in .xla


    Have anyone idea where is problem?[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Could be problem in onaction parameters?

  • Re: Controls OnAction Fails When Saved As Add-in .xla


    Try and run the code line by line by pressing F8 to run the code each individually and tell me what is the msg you get

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

  • Re: Controls OnAction Fails When Saved As Add-in .xla


    timgluz,

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!