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

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:

frmAanm.txtLog.Value = frmAanm.txtLog.Value & "(" & countClients & "/" & totalClients & ")" & vbCrLf

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.

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.