Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Closing Excel UserForm causes Excel to not be the active application
Actually, I found a reason, but it makes no sense - apparently a UserForm can be called from a procedure, but NOT a procedure that was called. I have a menu item that calls SUB1, which in turn calls SUB2. If the form is called in SUB1 or SUB2, when the form unloads Excel is no longer the...- jmcclen
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Closing Excel UserForm causes Excel to not be the active application
I've got a userform that when it unloads, it causes Excel to not be the active application, even if there is nothing else running on the desktop. I've tried activating a sheet before the unload, but it doesn't help. Any msgbox opened after the unload will exibit the same problem until the menu...- jmcclen
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
