I have some lengthy VBA loops, and I am trying to display a counter in a cell. In each loop I have it place the counter in the cell. It works fine and updates as long as Excel has focus. However, if I go to another application, the cell is no longer updated, until the loop finishes and the Excel screen is updated.
Is there a way to have the cell be updated even if Excel loses focus?
thanks
Fred
Is there a way to have the cell be updated even if Excel loses focus?
thanks
Fred