setdata with IF-statement and vba

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • setdata with IF-statement and vba

    Hello Palo-Team

    in order to avoid uncontrolled dataset eachtime a push F9 or Shift F9, i included the formula into an if-statment:

    =if(writeback=true;palo.setdata(....);"-")

    and i have a button with the vba-code :
    ...
    range("writeback")=true
    activesheet.calculate
    range("writeback")=false
    activesheet.calculate

    unfortunatelly it's not working.
    Do you know a workarround?

    The post was edited 1 time, last by akunz ().