You can also learn a lot about the events on controls by just sticking a
debug.print or msgbox line in each one. From the VBE IDE when you view the
form module, you'll see two scrolling lists on the top. The left one is for
the elements in the form and the right one is for the events that go with
that particular element. The names are pretty self-explanatory. The
sequence of events of for the workbook/worksheets are not quite as
self-documenting (like right-click event causes _selection event to be
triggered as well). The help files are actually pretty good at explaining
At 12:16 AM 03/04/2001, you wrote:
>From: Wassim Nassif [mailto:[log in to unmask]]
>Sent: Saturday, 3 March 2001 2:35 AM
>To: [log in to unmask]
>Subject: Sequence of Events
>Has anyone seen a document that describes what even is triggered when the
>user does something?
>Or a document that shows the sequence of events, I am talking about the
>order in which events are executed.
>I have a Userform that has a bunch of controls and I would like to know what
>is the best way to control these controls.
>Thanks for any help.