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.

Please Login or Register  to view this content.

Thanks in advance
Harribone

I have half solved the issue:

I have put the rest of the code within frmSorting_Activate which does the trick. The only problem is that the userform is just a blank white box without the text label.
(Even though this is not at all needed to actually do the data sort I always like to make everything look as clean as possible and it always ends up more hassle than it's worth!)