Run Macro from trigger/selection

[stabben23]

Hi,

Cant find a smart way to fire my macro "RefreshData". I have a macro that needs to be fired from inside Application.

I have variables vSecond =second(now(1)) , vReload= if($(vSecond)>50,1,0)

So when my vReload is 1 it should  fire the macro.

Any actions the fits my requirement? I have test some but without success.

[stabben23]

Hi Tamil,

I forgott the = sign in the variable. When a look in my text Box With the Variable I have $ expansion so it looks like the flag was 1,0.

But the variable it self was only the Expression.

[tamilarasu]

Staffan,

    Create an inputbox and add our created variable   vReloadTrigger using the inputbox wizard. Now, you should see 1 in the inputbox every 50 seconds and 0 after 60 seconds. If not, copy paste the expression from the above attached file and see whether you are able to see the values. Also, check whether you have entered same module name in the trigger action or not. If everything is ok, you can see the automatic reload window every 50 seconds. If you still face issues, please let me know.

[stabben23]

No issue, works as expected

[tamilarasu]

Great Staffan. Please close the thread by marking correct answer. It will help others (who browse for the similar problem) to find the solution.