I'm new to RE VBA and appreciate any assistance with the following problem :)

When I launch a VBA userform through a macro from the RE shell it does not appear on the Windows taskbar. So if I switch to another application (like Excel) I can't get back to the userform by clicking an icon on the taskbar or using ALT-Tab to rotate through windows. RE itself disappears from the Alt-Tab. There is still an RE icon on the taskbar but when I click it I go back to the RE and not to the userform. Since the userform is still open I hear the "thunk" that tells me a window is open and needs to be closed...since I can't access it I can't close it so effectively RE has crashed.

I get the same behavior whether the "ShowModal" property of the form is set to "true" or false.

Thanks in advance for any suggestions on correcting this!

Thanks,
Frank

This is a known issue with VBA and user forms. I think that there is a knowledgebase article about it somewhere but read my blog article for some more information: http://www.re-decoded.com/2007/02/the-case-of-the-disappearing-form/

 David

David,

Thanks --- this is very helpful and your blog is awesome! I found some other helpful things there as well.

Frank

Thanks, I am pleased that I could be of help

 David