Create a progressbar using Userform

Question

I have created a sub routine which calls 8 other subroutines from within and produces a spreadsheet of summary.

I want to create a progressbar to show the progress and which particular subroutine is running.  I am a bit confused at the examples I have seen in Microsoft website which suggests using a Userform.

I am using excel 2010 on Windows 7 professional.

Each of the 8 subroutines creates a worksheet in one workbook.

Answer 1

Hello,

John Walkenbach has a very easy to implement progress bar with a user form here: http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/

The user form calls the actual subroutine. In the subroutine there is a counter that is incremented and periodically updates the user form.

cheers, teylyn