• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Setting Tab Order of Controls within a Frame in Excel VBA

M

Maneesh Massey

Member
Hi,
I was about to complete my application with Excel VBA 2013, but somehow got messed up with the tab order of the text boxes and combo boxes on the userform within the frame. All the text boxes and combo boxes are within the frame and I do not need to set the tab order for the first text box. In order to skip this text box, I changed its tab stop property to false. When the userform loads, the focus goes to the second control which is a combo box which is what I want. The problem occurs when I try to tab to the third control, which is again a combo box and the tab order for all the other controls on the form do not happen in a logical or functional manner.
I tried to right click the frame and set the tab order from there but the tab order is still does not work correctly.
How should I set the tab order of all the controls within the frame ?
Please help.
Regards,
Maneesh
 
Get the Properties Window up
then click on each in order of your required usage
Start with Tab Stop 0 and work your way up
 
Hi, Maneesh Massey!
Click on the frame border, right (alternative) click, Tabulation Order, and there play moving up and down frame controls.
Regards!
 
You must log in or register to reply here.
Back
Top