If you link a scrollbar to a cell that cell can only contain a value, not a formula.
So the cell itself can not use the value from the result of a formula.

You can however populate the cell via code when the other cells change.
For this you will need to use code in the worksheet_Change event