Forum Discussion
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...
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.
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
As Hans previously stated, the function must be in a *standard* module. It works for me, after moving "MakrotestStart" from the sheet module "Tabelle1" to the standard module "Modul1."
- Hi, Thanks for the support, yes, Hans is absolutely right, Problem solved .
Best Regards,
Carsten