Forum Discussion

Carsten0764's avatar
Carsten0764
Copper Contributor
Mar 04, 2021
Solved

I want a macro to run in Excel 365 when a cell returns a certain value

Example: =WENN(E3=1;Macroname();"") so when E3=1 the macro with the name "Macroname()" should run. This isn't accepted, an error-message of "wrong syntax" is displayed, highlighting the "()" in th...
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Mar 05, 2021

    Carsten0764 

    In one of my previous replies, I wrote

     

    "Make sure that TestMakro1 is a function, not a procedure (sub) and that it is located in a standard module in the workbook with the formula."

     

    The function called in your formula is MakrotestStart. This function is located in the worksheet module of Tabelle1. That is precisely the problem! It should be in the standard module Modul1.

     

    See the attached version.

     

     

Carsten0764's avatar
Carsten0764
Copper Contributor
Mar 05, 2021

HansVogelaar Hello, Hans, sorry, I was away for a day and couldn't answer.

I'll attach a short Test-sheet with the problem and a couple of explanatory screenshots.

Thanks for having a look at this.

 

Best Regards,

Carsten

 

HansVogelaar's avatar
HansVogelaar
MVP
Mar 05, 2021

Carsten0764 

In one of my previous replies, I wrote

 

"Make sure that TestMakro1 is a function, not a procedure (sub) and that it is located in a standard module in the workbook with the formula."

 

The function called in your formula is MakrotestStart. This function is located in the worksheet module of Tabelle1. That is precisely the problem! It should be in the standard module Modul1.

 

See the attached version.

 

 

  • Carsten0764's avatar
    Carsten0764
    Copper Contributor
    Mar 05, 2021
    Hello, Hans, You're right, that solved it for me!
    I'm still pretty new in Office 365, so I didn't know that.
    Thanks for helping!
    Stay safe and healthy,
    Best Regards,
    Carsten

Resources