show userform ontop of anything that is happening in the background in excel

[gosa]

Hi,

I have a userform with some buttons and I'm using a textbox as a logbox to show some comments while the data is being processed.
I use something like this:

Please Login or Register  to view this content.

The problem is that excel is busy and the form becomes blank with a wheel turning and only when it's done does the form reappear completely.

With busy I mean that in my case for each item in a collection class a file is being made (xls) and it makes a file works in it, then closes it automatically and start with the next.
In the meantime I want to show which one is being processed but the form is blank and you can't see any label, textbox, button,...

Any advice to make sure the userform is shown. What happens in excel should be hidden in the background if possible.

Thanks in advance.

[Leith Ross]

Hello gosa,

There are several ways to keep a UserForm visible. The best approach depends on knowing what your code is doing. For that reason, you should post a copy of your workbook. If you can not then it will require a lot of posting of code, questions, and answers.

[gosa]

Hi,

Thanks for taking time to answer.
I will try to put an example so you can see what I mean.
It will be tomorrow I think cause I still need to work on some other parts.