Hi, I wonder whether someone may be able to help me please.

Using the example I've found here: http://www.vb-helper.com/howto_excel_show_splash.html, I've created a 'Splash Screen' userform to inform the user that the macro is running.

Independently, I'm able to view the form upon button click, and the progress bar scrolls performs as expected, but when I try to call my initial procedure (which also contains subroutines) within the form, the forms progress bar fails to display.

The code directly below is used to view the userform:

Please Login or Register  to view this content.
Could someone possibly look at this and offer some guidance on where I need to call my initial routine which is called "CreateAllData".

Many thanks and kind regards

Many thanks and kind regards