TAB keys instead of manual intervention to move between VBA controls

Each control you add is automatically assigned a tab value.

If you insert Frames those are assigned tab values too.

So if you have 3 frames each with 5 controls

pressing tab will move between the controls of frame One, then the controls in frame two and then in frame 3 and then back to one.

If you right click on a controls and then select properties.

Three Tab properties are listed,

***************************************************************
Tab Index. This tells you the order of the controls will be selected in.

Pressing tab goes from Tab 0 to 1, to 2 etc. Upwards.

Pressing shift and tab goes from Tab 2 to 1, to 0 etc. Downwards.

You can change the tab index of each control as you want.

***************************************************************

Tab Stop. This tells you if the cursor will stop at the control when you tab.


***************************************************************

Tab Key Behaviour. This will tell you if the cursor will tab within the control.
I assume that this is just for Text Boxes.

***************************************************************