Share via

Create a progressbar using Userform

Anonymous
2012-09-08T03:44:14+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2012-09-08T05:43:34+00:00

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

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful