Excel 2010 VBA macro - Notice the window display as the program continues without stopping

[softik]

This code brings up a window and announces that the program will continue after 1 sec:

Please Login or Register  to view this content.

However, what should be the code where the program does not stop, but would go further and inform the window at the same time for awhile that "The procedure searches for answers ..."?

Looking for a suitable code ...

[romperstomper]

You'll need a modeless userform that you can update as your code progresses.

[softik]

How do I most easily do this?

[romperstomper]

Add a userform, put a label on it and then when you want the message put up use something like:

Please Login or Register  to view this content.

then when you are done use:

Please Login or Register  to view this content.

[softik]

Thank you, romperstomper, it works well!

[romperstomper]

Glad to help.