Forum Discussion
Run a macro only once
Hello, I want a macro to run when the value in a cell meets a certain criteria but I want it to only run once, not every second or two for as long as the condition is met. So in addition to checking...
A function in a cell formula cannot change the value of another cell.
Will the user change the value of AT1139 or does it contain a formula?
HansVogelaarYes, AT1139 is normally empty and I want the function to run when another process puts text in it.
You write "I want the function to run when another process puts text in it." What other process?
- The cell contains an IFS() formula that, when one of several conditions are met, makes the value of the cell equal to one of several strings of text.
I am sorry that I did not provide complete information - I appreciate your help.
