Event Sequences

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

Hi All
Can anyone shed some light on the Excel event sequences or point me in the
right direction ?

What events sequences occur and in what order when userform controls are
clicked, entered, exited etc.

Is there some sample code that perhaps demonstrates the events and the
sequence ?

TIA
Cheers
Nigel
 
Frank's suggestion refers to workbook et al events, whereas you are
specifically referring to userform events.

Each of these events can be individually trapped, but occur when the user
takes that action. So Enter occurs when a textbox is entered for example,
click when a control is clicked, exit when it i is exited (all presuming
appropriate to that control). Obviously, some are order dependent, such as
you have to enter a textbox to add data to it, but that should all be
obvious.

What are you trying to do that needs this info?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks Franks, This addresses the workbook events but not the userform
controls. Any other ideas?

Cheers
Nigel
 
Hi
sorry didn't read your post carefully enough :-) Unfortunately I do not
have a list for these event sequence (though most of them are quite
obvious). But you can try the following:
- Create a userform
- for each event of your interest create code which just invokes a
messagebox with the respective event name
I know- not elegant, but working :-)
 
Bob,
More for my own understanding than a specific application. I am aware of
the events that result from the user interacting with a userform, and in
some cases will trigger a sequence of events. For example is it true that
say entering a textbox by clicking on it, triggers both the 'enter' event
and a 'click' event, if so in what order do they occur?

If my code acted on the first event, would the 2nd or 3rd etc., be actioned?

I had a mind some form of table that shows for each control the individual
actions and resulting sequence of event(s).

Cheers
Nigel
 
Nigel,

In your example, it would struggle to trigger the click event as there is no
click event for a textbox.

You may find this technique that I use as helpful to control events. A major
problem is that sometimes one event can fire another, as you state, so it is
sometimes better to stop the events triggering. I set a variable to control
this like so

Dim fEvents As Boolean

Private Sub cmdDo_Click()

if FEevents = False Then
fEvents = True
'o whatever
fEvents = False
End If

End Sub

Beacuase this sets the flag on entry, if itis re-entered within this event,
it will simple exit as the flag is alraedy set. Just before exit it resets
the flag.

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Nigel said:
Bob,
More for my own understanding than a specific application. I am aware of
the events that result from the user interacting with a userform, and in
some cases will trigger a sequence of events. For example is it true that
say entering a textbox by clicking on it, triggers both the 'enter' event
and a 'click' event, if so in what order do they occur?

If my code acted on the first event, would the 2nd or 3rd etc., be actioned?

I had a mind some form of table that shows for each control the individual
actions and resulting sequence of event(s).

Cheers
Nigel






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
Click to expand...
=---
 
Back
Top