Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Event Scope Problem
I have an Add-In where I have created a class which holds a couple of
application level events. In the class I declare a public Application object WithEvents. The class is instantiated in the Add-In WorkBook_Open event. When I load a workbook with the Add-In attached the events seem to fire ok on the workbook, it being the active workbook. However, I have a form on the Add-In activated from a toolbar button which is periodically displayed during a program loop for the user to make a choice. On the form I have a button which stops the program with the End keyword if the user wants to stop the program. When this button is pressed the code stops running ok but so do the application events. Any help appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Event Scope Problem
The End keyword should never be used. It completely terminates
all VBA code and reset all public variables to their default values. You should instead use Exit Sub or Exit Function to exit from the called procedure, perhaps returning a value indicating to the calling procedure that it, too, should call Exit Sub. In short, design your code so that End is never used. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... I have an Add-In where I have created a class which holds a couple of application level events. In the class I declare a public Application object WithEvents. The class is instantiated in the Add-In WorkBook_Open event. When I load a workbook with the Add-In attached the events seem to fire ok on the workbook, it being the active workbook. However, I have a form on the Add-In activated from a toolbar button which is periodically displayed during a program loop for the user to make a choice. On the form I have a button which stops the program with the End keyword if the user wants to stop the program. When this button is pressed the code stops running ok but so do the application events. Any help appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Event Scope Problem
Thanks
Mike Chip Pearson wrote: The End keyword should never be used. It completely terminates all VBA code and reset all public variables to their default values. You should instead use Exit Sub or Exit Function to exit from the called procedure, perhaps returning a value indicating to the calling procedure that it, too, should call Exit Sub. In short, design your code so that End is never used. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... I have an Add-In where I have created a class which holds a couple of application level events. In the class I declare a public Application object WithEvents. The class is instantiated in the Add-In WorkBook_Open event. When I load a workbook with the Add-In attached the events seem to fire ok on the workbook, it being the active workbook. However, I have a form on the Add-In activated from a toolbar button which is periodically displayed during a program loop for the user to make a choice. On the form I have a button which stops the program with the End keyword if the user wants to stop the program. When this button is pressed the code stops running ok but so do the application events. Any help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
Application level event help | Excel Discussion (Misc queries) | |||
Problem in Variable Scope | Excel Programming | |||
Generic questions about variable scope the Initialize event | Excel Programming | |||
Monitoring application-level event problem | Excel Programming |