Thread: adding usr defined event procedure of textbox in usrform ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
  
Posts: 123
Default adding usr defined event procedure of textbox in usrform ??
For TextBox1_GotFocus use the TextBox1_Enter event and for
TextBox1_LostFocus use TextBox1_Exit event.

These event can be used for other types of controls (CommandButton,
CheckBox) etc. also.
These are same as GotFocus and LostFocus events, and work same way when
ever the control gets or loses focus.

Additionally when the form is loaded, _Enter event for the active
control the will be fired. When the form is unloaded, _Exit event for
the control which was active, will be fired.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote