Results 1 to 2 of 2
2005-09-14, 07:53 #1
- Join Date
- Feb 2001
- Weert, Limburg, Netherlands
- Thanked 0 Times in 0 Posts
Control When Events Are Handled (VBA (97, 2000, XP, 2003))
Events are a powerful aspect of Excel programming. They enable you to make your application respond to user actions such as entering data into cells or clicking the print button.
If your application uses events, you will probably also need to be able to control whether or not an event executes its code or not (e.g. to avoid event looping or to enable your code to do things you are preventing your user to do through the user interface).
This article shows a method to gain fine control over which event fires and which does not.
NB: The examples are written in Excel VBA, but should work in any Office program.
2005-09-14, 08:03 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Control When Events Are Handled (VBA (97, 2000, XP, 2003))
As usual, a clearly written and useful article, thanks!
I often use this technique in Access - a Boolean variable in the module behind a form to control whether the form can be closed.