connecting progress bar to ok button on userform

[samz93]

Hi.

I have created a user input form on vba excel for a loan ammortisation table so the user is able to input the relevant values in the fields and on clicking ok the loan schedule is produced. I wanted to create a progress bar so that on clicking 'OK', while the loan schedule loads, the progress bar will show. On the userform for my progress bar, it only loads when the button below the progress bar is clicked. How would i go about connecting the loading of the progress bar to the OK button.
Below is the code im using for my 'OK' button and the separate code im using for my progress.

Code for OK button:

Please Login or Register  to view this content.

where macro_e is the calculation of the loan table and macro_f is the calc of the summary table




Code for my progress bar:

Please Login or Register  to view this content.

Any help would be greatly appreciated!
thanks!