progress bar userform inside userform not working

**kevinu** · 05-22-2018, 03:33 PM

I have a userform that deletes some data but it takes a long time. I'm trying to use a progress bar to let users know its working. I have a progress bar userform that I'm already using but I cant get it to work inside the userform.

The code inside userform2 that deletes info is: Basically it looks at option buttons then clears content of 6 ranges depending on the option button selected.

Please Login or Register  to view this content.

The progress bar userform1 code is

Please Login or Register  to view this content.

The progress bar was used in another part of the program so im trying to retrofit it to fit the Clear_click() code above. I know its not correct yet but i cant even start to debug it because it errors on the first line "userform1.show". Any help would be greatly appreciated.

**BadlySpelledBuoy** · 05-22-2018, 03:40 PM

When it errors out on the UserForm1.Show line and highlights it, press F8 repeatedly to step through the code line by line.
It will continue through the code and eventually you will get to the line that causes the issue.

Let us know what that line is and if possible attach a desensitized version of your file. Always much easier to help if we can see that.

BSB

**kevinu** · 05-22-2018, 04:58 PM

its sayin runtime error 401: cant show non-modal form when modal form is displayed. Ill try to make a sample and upload it.

**Norie** · 05-22-2018, 05:13 PM

You need to show your first userform modelessly.

To do that either set the ShowModal property to False or use this when opening the form.

Please Login or Register  to view this content.

**kevinu** · 05-22-2018, 05:41 PM

Here is the sample workbook. I had to erase the old progress bar code but the userform is there as userform1. when you open it click on the "file station" button and userform2 will open. I would like to have a progress bar that shows progress when the red "Clear data set" and "Clear all data" command buttons are activated\

Edit: Thx Norie that worked.. Still need to make it work but at least it runs now

If you have any suggestions on how to integrate that into the clear data codes i'd love the advise. I need it to update the progress bar after each range has been cleared... 6 or 7 total ranges. Not sure how to do that yet.