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:

Sub cmdShowSplash()
Dim frm As fmSplash
Dim i As Integer
Dim j As Integer

    ' Deactivate the keyboard.
    Application.OnKey "^d", "KeyboardOn"
    Application.DataEntryMode = True

    ' Display the splash form non-modally.
    Set frm = New fmSplash
    frm.TaskDone = False
    frm.prgStatus.Value = 0
    frm.Show False

    ' Perform the long task.
    For i = 0 To 100 Step 10
        frm.prgStatus.Value = i
        ' Waste some time.
        For j = 1 To 1000
            DoEvents
        Next j
    Next i

    ' Close the splash form.
    frm.TaskDone = True
    Unload frm

    ' Re-activate the keyboard.
    Application.DataEntryMode = False
End Sub
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