Hello all
I am currently working on a project in which i have created a toolset which calls different subroutines stored in a module. Each button works fine. My problem is that I have decided that i would like to use a progress bar. I have a form which has 2 progress bars on it. The progress bar works well actually, when run by itself. The bar was taken from another website giving examples of how to create a progress bar using a UserForm.

My actual Problem

The user clicks a button on the toolbar and the "WorkMacro" is called. Inside the work macro i have placed a call to the openform sub which, opens the userform. The userform has code under the initilize subroutine which establishes the length and location of the bars. This is where the code stops. it does not go back to the "WorkMacro" My understanding is that as long as the userform is open, only code behind the userform can function. Is there any way to get around this and resume my "WorkMacro" while leaving the userform visible.

In sections of my "Workmacro" i have placed a function which runs to update the userform one. This function is called the progress function. so it to follows the same problem. Everytime i want to resume my work function i need to close the form. even if i unload the form at the end of progress it will still flash the form fequently and would likely not be all that helpful. Suggestions would be greatly appreciated.