How can I display script progress?

[ozboomer]

Hi, again...

When processing a PlanMaker worksheet that is complex or has many rows/columns to iterate through, the processing can take significant time.

Is there any way that a 'progress' indicator... or some 'messasge' system be used to indicate progress?

MsgBox() and Dialog() both need to be acknowledged and have no timeout feature, so they are not helpful when trying to update the user on how the work is progressing without interrupting the processing.

I could use Shell() to run something external to PlanMaker... but that seems more than overkill and is cumbersome... and keeping the worksheet displayed and updating it slows-down the processing.

I'd appreciate any suggestions on how to tackle this issue.