Code that loads another userform but stops until user interacts

Hi,

I have the below but of code which works fine except for one slight problem. Once the frmSorting is opened up the user then has to close this manually before the code moves to the next line.
Basically I am creating a user friendly 'sort by' userform and wanted a "Sorting..." userform pop up whilst it sorts the data so the user is aware that Excel is doing it's thing.

In my experience this is either a simple fix that is staring me in the face or it is the complete opposite - impossible.

If optByDate.Value = True Then
    Unload Me
    frmSorting.Show  'this bit works fine but the next line isn't executed until the user closes this form
    Call mcrSortByDate
    Unload frmSorting
End If

Thanks in advance
Harribone