Hello,
I have an Excel document that users can input data to which has a userform which enables the write back via a cell which is switched to "Y"/"N" enabling the writeback formula (see below)..
=IF(AND(AB$8="Y",O15<>""),INFOR.WRITE.VALUE(
I have noticed that the calculation does not complete (using application.calculatefullrebuild) until after the code has executed so the data is not submitted as the code switches the cell back to "N"..
is there a way to force a full calculation which initiates the infor.write formula to complete during the VB code execution?
Many thanks,
Stuart
