If your data is extremely long - say a hundred thousand rows, the task can take up to 5-10 minutes to do.
While the task is being done there is almost always a status message being updated at the bottom left of the screen. This is a very rare and almost all the time the task is still being done and will be completed in a few minutes.
When macros take a long time to run, people get nervous. For example, the following macro uses a Sub Highlight Long Headings( ) Dim para As Paragraph For Each para In Active Document. Select Tools→Macro→Visual Basic Editor, choose Normal in the Project Explorer (near the top left of the window), and then select Insert→User Form. Align the 10 frames as best you can in a single row.
If you are running one of our add-ins, they normally will complete any task in just a few minutes.
Most will complete their tasks in just a few seconds.
If your device contains a large number of files, the process can take from several minutes to an hour.
If your device appears in i Tunes, you can configure sync options, and you can sync content, the process is complete.
If you hold down the CTL key and press the BREAK key, this will interrupt the code and display a Microsoft Excel visual basic dialog box like the following When this box appears, click on the Continue button. If Excel is truly frozen, which is extremely rare, you will need to kill Excel via the Task Manager.
Press ALT-CTL-DELETE keys, select Excel and click End Task. The primary cause of lockups in Excel are memory related.The code to put a message on the status bar is shown below.When you use the status bar to display a message to the user, that message will be displayed until your code returns control of the status bar back to Excel. This may be a problem when you use it to display a "Macro Complete" message -- the message will always remain in the status bar.The Status Bar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro.This way, you can let the user know that a macro is still running.The status bar portion of the Excel screen gives you a simple and convenient method do display message to the user.