Hello all,
This is a bit of a rehash from http://www.mrexcel.com/forum/excel-questions/519492-cannot-setfocus-userform-control.html
Many thanks to all of the people who have added to this post: I will refer to the Workbook posted by Jaafar Tribak: http://www.box.net/shared/50tk7f8oai
I am working on an implementation of the code much as described in the previous posts, I have numerous sheets that have many Frames containing many TextBoxes.
(In some cases I have as many as 562 TextBoxes within the Userform. Code like this is a great benefit to the end user where the active textbox can be highlighted.
The current code works as long as the TextBoxes are not located within a Frame. For the example that Jaafar posted... If TextBox3 is placed inside a Frame, the module no longer fires.
Is there any way of making the code work on all TextBoxes regardless if it is inside a Frame, or even a Frame inside a Frame?
This is a bit of a rehash from http://www.mrexcel.com/forum/excel-questions/519492-cannot-setfocus-userform-control.html
Many thanks to all of the people who have added to this post: I will refer to the Workbook posted by Jaafar Tribak: http://www.box.net/shared/50tk7f8oai
I am working on an implementation of the code much as described in the previous posts, I have numerous sheets that have many Frames containing many TextBoxes.
(In some cases I have as many as 562 TextBoxes within the Userform. Code like this is a great benefit to the end user where the active textbox can be highlighted.
The current code works as long as the TextBoxes are not located within a Frame. For the example that Jaafar posted... If TextBox3 is placed inside a Frame, the module no longer fires.
Is there any way of making the code work on all TextBoxes regardless if it is inside a Frame, or even a Frame inside a Frame?