AWE_ProgressBar - MACRO PROGRESS BAR, STATUS, AND A CANCEL BUTTON. Easily display your macro's progress and status. Take the guesswork out of, "Is the process still running?" or "How much longer?".
- Allow your user to press a cancel button and stop the processing.
- Show one or multiple progress bars at the same time, e.g. show an overall progress bar and sub-process progress bars at the same time.
- Show detailed status to your user on what your process is doing.
Implement the FREE, open-source AWE_ProgressBar into your Excel Spreadsheet today and take the guesswork out of your macro's percent complete and status.
Example
Example Macro...
Load AWE_ProgressBar
AWE_ProgressBar.Initialize MaxRecords:=10, ShowCancelBtn:=True, ShowProgressAtIntervalNbr:=1
'--- Simulate displaying a AWE_ProgressBar during processing ---
For i = 1 To 10
'--- Increment the progress bar ---
AWE_ProgressBar.ProgressNb = i
'--- Check to see if the user clicked the cancel button ---
If AWE_ProgressBar.IsCancelled = True Then Exit For
'--- Display an optional progess message ---
AWE_ProgressBar.ProgressMsg = "Display an optional user friendly message here. " & i
'--- Simulate processing ---
Application.Wait (Now + TimeValue("0:00:1"))
Next i
'--- Destroy the progress bar ---
AWE_ProgressBar.Destroy
Note, if you see the text "SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted", then follow the instructions - Know how to allow VBA macros to run in files you trust. You should always carefully examine all pre-written Macros from this or any website for harmful code before executing them in your environment. Once downloaded, export and import the AWE_ProgressBar Form to other Excel Workbooks. Read Use the Project Explorer for help on exporting and importing Excel Forms.
Add comment
Comments
Easy implementation, worked perfectly the first time. Thanks for the time saver!