progress bar

  1. M

    Progress Bar

    Hi, the code below is to import file names into excel from any given folder. I'd like to have a progress bar but I'm not sure how it would work. I thought if I could work out how many file names are going to be imported before the Macro does it's work, I could use it to do a progress bar...
  2. MarkCBB

    Add a Progress bar to a user form

    HI there VBA Guru's I am using the following code to filter some Pivot Tables on a worksheet, however it takes sometime to run the marco, I would like to have a progress bar in the user form to show the progress of the macro. however I have not been able to insert a progress bar into the user...
  3. MarkCBB

    Progress Bar

    Hello, I have a VBA code that calculates random numbers for about 5 seconds, it it possible to add a Progress bar to the excel sheet? If so where could I find the control?
  4. L

    possible to create combined progress charts?

    Hi, I am trying to create a progress bar from charts and am stuck. I am trying to create create 3 subprogress bars within 1 overall bar. Here is my example. I have 100 items that get processed in 3 stages. 80 items have completed stage 1. 60 items have completed stage 2 20 items have...
  5. M

    Simple Progress Bar

    Ok, so I am looking to do a very simple progress bar and need some help with the code. I am still learning VBA and can't quite figure out this one. What I am looking for is something like this: Sub MyMacro() Create a progress bar window with the indicator at 0 Run the first part of my macro...
  6. J

    Progress Bar Won't Work

    I have modified a progress bar that was made by Andy Pope, however I can not get it to work. When I set the form to modeless it appears blanked out on the screen, when I run it in normal mode it works perfect but my code will not work until the progress form has finished running it's course...
  7. D

    How to determine the progress of a macro?

    Hi All, I currently am using a very lengthy macro that opens and updates 30 other spreadsheets. It currently takes between 9 and 15 minutes depending on what is doing. I have a very basic screen update built into it that shades a progressive cell in black to show its progress. I have...
  8. H

    Progress Bar for a slow macro

    Hello People, I have a macro which takes a looong time to execute - opening 20+ files and copying information from each into one master file. I have used the application.screenupdates = false command to stop the screen jumping all over the place while this happens, which is a greaet improvement...
  9. P

    Progress Bar and Screen Updating Question

    Hello all. Sorry - this is a bit drawn out.... I have a large 2 sheet database and a macro that compares matched cell info on each line of each sheet. On finding a match the macro tabulates the findings (departmentises each group). All works great. I also have a progress bar (in smoothed mode)...
  10. L

    Macro Application Question

    Hello All, I implemented the "custom dual progess bar" per the instructions in the link below and the demonstration works good ("ShowForm") in my file. However, it is not being applied to the macros that already exist in my file. Is there possibly some code missing which would show allow me to...
  11. B

    Faking an animated image in a userform?

    I've gathered that it's not possible to place an animated GIF like this: in a userform in Excel. As you might have guessed, I've created a macro that, depending on user inputs, can take a bit of time to run, and I want to display something to let the user know that Excel hasn't locked up...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top