Hi there and welcome
It is "normal" behaviors in such that it occurs when you enable forcefullcalculation. The reason is that since there are no formulas to calculate for the text boxes, it does not recalculate.
If though you enter into the onchange event on the worksheet the VBA code to assign the value to the text box, so that it runs this every time a change occurs, it should populate this way.
What happens in your sheet when you do this?
yes, its the only workaround you can use to get it running, else you would need to disable forcefullcalculation.
I just wanted to ensure you were able to code this.
If you would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.