Excel screen not updating
Posted on 2014-11-21
I have an Excel VBA application that process SKU numbers. During the process, a form I have to show the user which item is being processed. Suddenly, it has stopped updating after just the first 3 items. Each item takes about a second or two. Also, Excel and the caption on the form starts displaying "not responding". I tried writing to the status bar, but it stops after the 3rd item also. Another user has been complaining that his stops after 33 items.
What is going, and how do I fix it?