How can I create a progress bar in Excel VBA?

by

Sometimes a simple message in the status bar is enough:

Message in Excel status bar using VBA

This is very simple to implement:

Dim x               As Integer 
Dim MyTimer         As Double 

'Change this loop as needed.
For x = 1 To 50
    ' Do stuff
    Application.StatusBar = "Progress: " & x & " of 50: " & Format(x / 50, "0%")
Next x 

Application.StatusBar = False

More Related Contents:

  1. Print function selecting wrong Type of Change option excel vba
  2. Format Cell Contents
  3. Excel formula checklist in employees
  4. How do I put double quotes in a string in vba?
  5. What is the difference between .text, .value, and .value2?
  6. How can I URL encode a string in Excel VBA?
  7. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  8. Check if the file exists using VBA
  9. Trying to use variables as values vba to sql
  10. How to insert an embedded picture?
  11. How to call a macro from a button and pass arguments
  12. Obtain attribute names from XML using VBA
  13. VBA (Excel) Dictionary on Mac?
  14. Paste Excel range in Outlook
  15. Refresh Excel VBA Function Results
  16. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  17. VBa conditional delete loop not working
  18. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  19. Concatenate column headers if value in rows below is non-blank
  20. “Can’t find Project or Library” for standard VBA functions
  21. How do I issue an HTTP GET from Excel VBA for Mac
  22. Update excel sheet based on outlook mail [closed]
  23. Export chart as image – with click of a button
  24. Error13 in Excel VBA in data file
  25. Change font color for a part of text in cell
  26. Create a new object using the text name of the class
  27. Excel cell from which a Function is called [duplicate]
  28. How to extract text within a string of text
  29. GET pictures from a url and then rename the picture
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment