Hi All,
I need to know on how to code for using the TAB keys to navigate between VBA controls placed in an userform. Hence no need to point out in the text box, combo box, etc to enter the data.
Thanks!
Hi All,
I need to know on how to code for using the TAB keys to navigate between VBA controls placed in an userform. Hence no need to point out in the text box, combo box, etc to enter the data.
Thanks!
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.
***************************************************************
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi,
Thank you so much...It is exactly the one which i expected for...!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks