progress indicator problem

**77anders** · 02-24-2009, 05:01 AM

Hi
I've a INPUT sheet and a RESULT Sheet.
on the I NPUT sheet there is a button, and when clicked a macro is started putting values into the Result sheet with a loop.

For the progres sbar I've follows examples using a label control within a userform .

SO the vb code in teh Button_click Sub is something like this

Please Login or Register  to view this content.

THe problem is that when the userform is displayed, I've to press the (x) close button in order for the loop (with i) to continue..

ANy suggestion how to get this to work?

**Andy Pope** · 02-24-2009, 07:35 AM

If the button is on the worksheet rather than the userform then the first reference to the userform will cause it to load. And unless you set the ShowModal property to false at design time the form will automatically load as Modal. This means you need to unload the userform before your loop will continue.
Once it does continue you will have to unload the userform again. And this will repeat until the loop is completed.

So either set the property at design or load the userform before the loop is entered.
Also remove the Activate method from the loop.

progress indicator problem

LinkBack

Thread Tools

Rate This Thread

Display

progress indicator problem

Re: progress indicator problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions