VBA Splash Screen As Macro Runs

[hobbiton73]

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

I'm trying to put together a 'Splash Screen' which is visible to the user as a rather long macro runs.

I've done quite a bit of research and found a suitable example here: http://www.vb-helper.com/howto_excel_show_splash.html.

I've created a general module and inserted the following code:

Please Login or Register  to view this content.

Then inserted the following code to the user form:

Please Login or Register  to view this content.

I've run the user form in isolation and this works as expected, but I'm having a little difficulty in getting this to run whilst my macro runs.

The code below is the macro which I'm wanting to run whilst the form is visible, then once finished allow the form to fade out:

Please Login or Register  to view this content.

I've been trying to get this to work for a few days now, sadly without any success, so I just wondered whether someone could possibly look at this please and offer some guidance on how I may integrate the two.

Many thanks and kind regards

[Izandol]

If you wish to show progress meter, you must have a way of determining percentage completion for main routine. I do not see accurate possibility for the code you have now but you may apply same percentage to each task. Code will be like:
Userform:

Please Login or Register  to view this content.

Module:

Please Login or Register  to view this content.

I have not tested.

[hobbiton73]

Hi @Izandol, thank you very much for taking the time to reply to my post and for putting the solution together, I really appreciate it.

The form works fine as does the progress bar. The only item which I can't display is the label which tells the user what is happening which seems a little strange, but I'm sure I'll be able to work it out.

All the best and kind regards