LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default 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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter date in userform using Calendar Control Scotty9349 Excel Discussion (Misc queries) 1 March 4th 09 07:02 PM
"Enter" event for text box control? Chrisso Excel Programming 5 August 3rd 07 12:34 PM
Selecting control on userform with part of control name (set question) Keith Excel Programming 4 January 10th 07 02:24 PM
MsgBox in Enter event causes combobox not to run Change event Richard Excel Programming 0 March 6th 06 02:52 PM
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"