+ Reply to Thread
Results 1 to 6 of 6

Tabindex on VBA Spreadsheet

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Tabindex on VBA Spreadsheet

    Stock sample.jpg

    Hi,

    I am trying to use tab index on a vba worksheet so i everytime i tab it goes in the order i want. I have managed to do it to some degree but on some boxes it either skips or wont tab into the next section and i dont know why. See attachment, this may make it clearer as to what i am trying to accomplish. Any help would be much appreciated.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Tabindex on VBA Spreadsheet

    Welcome to the forum. We would have to see the userform in context to answer a question that specific.

    To attach a workbook, click the 'Go Advanced' button below and use the paperclip in the toolbar to navigate to your file.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    11-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Tabindex on VBA Spreadsheet

    STOCK CONTROL SAMPLE.xlsm

    Thanks for your reply. Please see attachment. Would appreciate help with this.

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Tabindex on VBA Spreadsheet

    It looks like you had some wonky settings for the tab stop property on some of your frames. Try this: STOCK%20CONTROL%20SAMPLE Solus Edit.xlsm

  5. #5
    Registered User
    Join Date
    11-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Tabindex on VBA Spreadsheet

    Thanks for the input. Is this referring to the Tabstop which should be showing as 'true' as opposed to 'false'?

  6. #6
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Tabindex on VBA Spreadsheet

    Thats correct. Plus some of your controls had the tab stop disabled.

+ 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. [SOLVED] How to reference Controls in a Userform based on the control's tabindex instead of name?
    By bmxfreedom in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-05-2013, 02:27 PM
  2. Skip to next TabIndex
    By NTB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2011, 10:50 AM
  3. multipage tabindex
    By JT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2005, 09:05 AM
  4. Replies: 1
    Last Post: 02-08-2005, 06:06 AM
  5. [SOLVED] Problem with Tabindex
    By Toppers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-05-2005, 05:06 AM

Tags for this Thread

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