1

Using Excel 2002 and have a VBA "app" that has some UserForms. The main UserForm contains a number of textboxes that fire various Enter/Exit events.

I am now running into a issue where one of the textbox exit events fires 2x in a row (I know because a messagebox appears each time).

Is there some means within Excel VBA to track all the events that fire and their sequence without writing code in every event/procedure?

Community
  • 1
  • 1
John M
  • 14,338
  • 29
  • 91
  • 143

1 Answers1

2

Don't know the answer to your question, but inserting this code will help prevent firing unwanted events:

Application.EnableEvents = False   'avoid self firing events

  'run your code....

Application.EnableEvents = True    're-enable events
iDevlop
  • 24,841
  • 11
  • 90
  • 149