+ Reply to Thread
Results 1 to 3 of 3

VBA Tabe Shifting

  1. #1
    Registered User
    Join Date
    12-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    68

    VBA Tabe Shifting

    Dear all

    i have vba userform on excel
    it has about 20 textbox

    usually i have to navigate between them using enter key or tab key

    BUT
    it jumps from box 3 to box 6
    and from box 11 to 8
    and from box 9 to 17

    there are maney like this

    please
    I need to know how to organize this sequence with the way I need ???

    thanlks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA Tabe Shifting

    Right click the userform and select Tab Order.

    Then you'll have a dialog where you can change the order of the textboxes.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: VBA Tabe Shifting

    thanks so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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