Userform Control Enter Event

D

donbowyer

Excel 2003 / Win XP
If I understand correctly, on a UserForm, the Clic event is triggered by
clicking any control and the MouseMove event is triggered by moving the mouse
over any control.
I would like to know what triggers the Enter event?
 
D

Dave D-C

From the {XL97) help:
Enter occurs before a control actually receives the focus from a
control on the same form. Exit occurs immediately before a control
loses the focus to another control on the same form.

The Enter and Exit events are similar to the GotFocus and LostFocus
events in Visual Basic. Unlike GotFocus and LostFocus, the Enter and
Exit events don't occur when a form receives or loses the focus.

Do you find it works this way?
 
D

donbowyer

Hi Dave
Thanks for your reply which has allowed me to prove to myself that if a
control if given the focus, then the Enter Event for that control will be
triggered.
However I don’t see the value of this, if the Enter Event has to be
triggered by another event.
Perhaps it would allow some action to be arranged after the Enter Event and
before the Set Focus Event, but I can’t see why this might be beneficial.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top