Jul 21, 2004 #1 JohnAcc Technical User Aug 13, 2003 143 GB Hi All, I have a userform that has some textboxes on. When the userform is initialized the textboxes are populated with data from cells in the workbook. Does this trigger the textbox_enter event procedure ? Rgds, John
Hi All, I have a userform that has some textboxes on. When the userform is initialized the textboxes are populated with data from cells in the workbook. Does this trigger the textbox_enter event procedure ? Rgds, John
Jul 21, 2004 #2 fumei Technical User Oct 23, 2002 9,349 CA No. The textbox has not been entered. Gerry Upvote 0 Downvote
Jul 21, 2004 #3 S SkipVought Programmer Dec 4, 2001 47,486 US John, [Enter]/[Exit] are two events for a text box. So when you Activate the userform, the control with the TabIndex = 0 fires the Enter Event. Skip, Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244 Upvote 0 Downvote
John, [Enter]/[Exit] are two events for a text box. So when you Activate the userform, the control with the TabIndex = 0 fires the Enter Event. Skip, Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
Jul 21, 2004 #4 fumei Technical User Oct 23, 2002 9,349 CA Ah, true. I did not assume the textbox was TabIndex 0. Gerry Upvote 0 Downvote