Hello!
I have the following - strange - problem.
I want to set the interior color of a range object in VBA. So far so
good. I created a code and added it to the click event of a button. And
it works fine:
Worksheets("Sheet3").Range("R1").Interior.ColorIndex = 17
But I want to have this code somewhere else. I wrote a class which is
called via a function, which is embedded in a cell. The function of the
cell is =fctXY(a;b;c) etc...
This function uses my object which calls the function that changes the
cell color. But nothing happens. The color doesn't change? I already
tried to turn the automatic cell calculation off, but the same result -
nothing happens. I also can not write a value into another cell when
I'm in the class function which is called by the formula in the cells
Can someone tell me why? Is there a lock for all the cells while the
formula is calculated? Can I turn this off?
Thank you for your help!
Bye,
Christoph
Bookmarks