Userform Control Enter Event
 

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.

Remarks

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?

donbowyer wrote:
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?

Userform Control Enter Event
 

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 dont 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 cant see why this might be beneficial.

--
donwb


"Dave D-C" wrote:

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.

Remarks

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?

donbowyer wrote:
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?