Hi All
I have two files : A and B. I am writing a VBA in file A that generates some value and writes that in a cell in file B. in file B macro, there is a Function F and there is a cell in which a formula written that used this function F that generates a True or False value based on the change in that Cell value I talked about in the beginning of this question.
It looks like, from VBA of the file A, it's not possible to enable such a function in another VBA macro and used as a formula. Could someone propose a solution please ?
I have two files : A and B. I am writing a VBA in file A that generates some value and writes that in a cell in file B. in file B macro, there is a Function F and there is a cell in which a formula written that used this function F that generates a True or False value based on the change in that Cell value I talked about in the beginning of this question.
It looks like, from VBA of the file A, it's not possible to enable such a function in another VBA macro and used as a formula. Could someone propose a solution please ?
