VBA/API

Re: UserForm not on Windows taskbar

David Zeidman — Tue, 01 Jul 2008 22:15:03 GMT

Thanks, I am pleased that I could be of help

David

Re: UserForm not on Windows taskbar

Frank Dean — Tue, 01 Jul 2008 16:20:47 GMT

David,

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

Frank

Re: UserForm not on Windows taskbar

David Zeidman — Mon, 30 Jun 2008 15:32:11 GMT

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

UserForm not on Windows taskbar

Frank Dean — Mon, 30 Jun 2008 14:59:03 GMT

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