+ Reply to Thread
Results 1 to 4 of 4

Order of userbox entry

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    Hamilton, Ontario
    MS-Off Ver
    Excel 365
    Posts
    4

    Order of userbox entry

    I am really new to visual basic and am trying to create a userbox for entry of data. I created it, and it worked great, however when I realized I had forgotten something and tried to add it, when I run it and test it out.. tabbing through the userform it goes in the order that I created the boxes and not the order they show on the form. I hope this makes sense and someone can help me fix this.

    Thank you

  2. #2
    Registered User
    Join Date
    11-03-2011
    Location
    Shelton, CT
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Order of userbox entry

    When you design your form, each item has a TabIndex in the properties table.. just number them accordingly to follow your tabbing order

  3. #3
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Order of userbox entry

    Hi

    Have a look at the TabIndex property and resequence to suit your requirements.

    rylo

  4. #4
    Registered User
    Join Date
    11-13-2011
    Location
    Hamilton, Ontario
    MS-Off Ver
    Excel 365
    Posts
    4

    Re: Order of userbox entry

    thank you so much... so easy too.

+ 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