Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
change event procedure | Excel Programming | |||
Event Procedure Programming | Excel Programming | |||
textbox formula outside procedure | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |