+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : cursor display vba excel

  1. #1
    Registered User
    Join Date
    05-06-2012
    Location
    Lisbon,Portugal
    MS-Off Ver
    Excel 2010
    Posts
    79

    cursor display vba excel

    hi
    How to display the cursor follow the order of filling out in userform
    thank you

  2. #2
    Forum Contributor
    Join Date
    05-04-2012
    Location
    Stamford,Connecticut,USA
    MS-Off Ver
    Excel 2003
    Posts
    105

    Re: cursor display vba excel

    All objects in a form have properties. In the miscellaneous category you can indicate the Tab Index order that you want it starts with object 0.
    If you are pleased with a member's answer then use the Star icon to rate it.Remember to mark your questions Solved and rate the answer(s)

  3. #3
    Registered User
    Join Date
    05-06-2012
    Location
    Lisbon,Portugal
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: cursor display vba excel

    Hi
    what I wanted is to put the cursor moving from box to box in the order a user has to put data in them.
    Thank you
    jdasp

  4. #4
    Forum Contributor
    Join Date
    05-04-2012
    Location
    Stamford,Connecticut,USA
    MS-Off Ver
    Excel 2003
    Posts
    105

    Re: cursor display vba excel

    That is what the tab index is for... to control the order. The first box will have a tab index = 1 the second a tab index=2 and so on, based on the order you want the user to put the data in them.

  5. #5
    Registered User
    Join Date
    05-06-2012
    Location
    Lisbon,Portugal
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: cursor display vba excel

    Hi RaulR
    I apologize only now able to respond. Thanks for the reply but I tried by tab index as through the tab order. both did not work. I think there is something that is missing. I do not know

+ 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