Display Form running AVI File while executing macro on spreadsheet
Posted on 2005-05-04
I have written a macro that performs some actions on an Excel spreadsheet. It takes about a minute to completely execute. I want to display a form with an animation control that runs a working AVI file while Excel continues to run the macro. I have placed the "DoEvents" in the Inialize event and tried it in the activate event of the form. I have also tried to place it in the macro in the line above the line I call the form show, but when I run the macro the form displays and the AVI is running but the next line of code in the macro does not execute until you close the form. Can anybody tell me if this is possible and what I can do to make this happen. Thanks!!