UserForm appearing behind other opened windows 1

[dvirgint]

Hello,

As the title implies, I have some userforms that appear while a macro is running, however if there is more than one application running at the same time (ex. Internet Explorer, Word, etc), the userform appears behind the other windows.

I've seen in a number of forums that it is possible to have the userform window appear in front of all other opened windows (ex.

http://tek-tips.com/viewthread.cfm?qid=1385267)

I have not been coding for very long, and I don't understand this solution. Is this the only way, or is there another?

 

[Andrzejek]

The main question here is: do you really want to do that?

If your User decides to run your macro, but wants to use IE or Word or any other application while your macro is running, do you want to over-write what your user wants and force your Form over user's decision?

Users are your clients, did you ask them if that's what they want?

Have fun.

---- Andy

 

[dvirgint]

Thanks for the quick reply. The macro isn't very long to run, and they won't have time to do anything else... so yes I do want to force the userform to be on top.

Thanks

 

[UnsolvedCoding]

Check out this link

http://www.excelforum.com/excel-programming/684263-keep-userform-on-top.html

 

[dvirgint]

Wonderful, thanks for the info. That solved my problem.