ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adding usr defined event procedure of textbox in usrform ?? (https://www.excelbanter.com/excel-programming/319807-adding-usr-defined-event-procedure-textbox-usrform.html)

tom taol

adding usr defined event procedure of textbox in usrform ??
 


i want to make two event procedure(TextBox1_LostFocus,TextBox1_GotFocus)
except default event(TextBox1_Change,
TextBox1_KeyDown,TextBox1_MouseMove...)

how to add event proc in default textbox????
please,,,

thank you very much.

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

Sharad

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!

tom taol

adding usr defined event procedure of textbox in usrform ??
 


thank you very so much
hqppy to you for new year(2005)

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


All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com