+ Reply to Thread
Results 1 to 3 of 3

TAB keys instead of manual intervention to move between VBA controls

  1. #1
    Registered User
    Join Date
    03-05-2016
    Location
    India
    MS-Off Ver
    6
    Posts
    16

    Question TAB keys instead of manual intervention to move between VBA controls

    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!

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: 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.

    ***************************************************************
    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.

  3. #3
    Registered User
    Join Date
    03-05-2016
    Location
    India
    MS-Off Ver
    6
    Posts
    16

    Re: TAB keys instead of manual intervention to move between VBA controls

    Hi,

    Thank you so much...It is exactly the one which i expected for...!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. manual changing of keys in combobox list
    By Nitzan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 05:22 AM
  2. Hpw do you move a chart with the arrow keys?
    By ChrisNor in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-29-2013, 12:52 AM
  3. Use of tab keys on Active-X Controls crashes Excel
    By mechbhaskar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2011, 01:59 AM
  4. Identify Source of Manual Move Operation
    By miguel3d in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 03:26 PM
  5. vb code to select all files from a folder without manual intervention
    By ravivaliya in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-08-2009, 04:12 AM
  6. Automatic updation of workbook without any manual intervention
    By engrzubair in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2007, 10:31 AM
  7. Arrow keys won't move cursor
    By Walterius in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1