excel - Function Output in Different Cell [RESOLVED] -
I am trying to write a function in a cell, and then use that cell's address as a reference point Trying to do, I want to change the value of the cell on Sheet 2 Basically, I am trying to generate two different outputs on each separate sheet on each output. Here's what I've done so far:
version application as function test (). Collar Worksheet Seals (Application.Collar.Row, Application.Color.Colume) .ro application. Collar Worksheet call (application caller.rows, application.color.column). Column sheet 2. Seals (A + 1, B + 1). Value = 8 & Function Its goal is to type "= test ()" in cell A1 on Sheet1, and A1 will be equal to zero, while cell B2 on Sheet 2 Will be similar. I have heard rumors that the UDF in Excel will not be allowed to affect the change in any other cell which was written on it, other than that, but I really do not want to believe in the rumor!
You combine (UDF) and an event macro You can get your goal together.
UDF A1 and event macro will detect this event and change the cell on the second sheet.
Comments
Post a Comment