switching out of Excel with userform open

[Smallweed]

I have a userform that remains open as a tool to the user and gives them the
choice of leaving the focus on it or the active workbook. If the form
happens to have the focus when I Alt-Tab to another application (e.g.
Outlook), alt-tabbing back shows me the userform but not Excel, that is, the
userform floats on its own above Outlook and I can't see Excel.

Any ideas how to deal with this? It can be resolved by clicking a couple of
times on the Excel icon in the taskbar but I like Alt-Tab and I know other
people who'll be using this are the same!

I guess an approach would be to find an Excel-loses-focus event and use this
to run AppActivate Application.Caption or some such to move the focus back to
Excel just before switching to the other application but I haven't found this.

 

[RB Smissaert]

Use the SetWindowLong API as explained here:

http://www.cpearson.com/excel/SetParent.htm

RBS

 

[Smallweed]

Thanks for that - interesting code! I seem to get a problem with it that
Excel now completely vanishes off the Alt-Tab list.

 

[RB Smissaert]

You probably coded something wrong.
Post your code and we will see.

RBS