+ Reply to Thread
Results 1 to 3 of 3

Not move to next Textbox after press ENTER/TAB Key, after SetFocus

  1. #1
    Registered User
    Join Date
    01-10-2017
    Location
    Pahang, Malaysia
    MS-Off Ver
    2010
    Posts
    41

    Not move to next Textbox after press ENTER/TAB Key, after SetFocus

    I have a develop a userform...then after press one button, I've put SetFocus command in order to ensure cursor located in specific Textbox. Then after key-in required info in the TextBox, I like to move to next textbox by pressing ENTER key, it only move to next line in a same textbox. If I press TAB key, also not moving to next Textbox.
    Ajimieta Kuantan

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,016

    Re: Not move to next Textbox after press ENTER/TAB Key, after SetFocus

    In the VB Editor, display the form, then look at the Properties window for each textbox.

    Insure TabStop is set to TRUE and the TabIndex number is in the order you want the Textbox's to accept focus.

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Not move to next Textbox after press ENTER/TAB Key, after SetFocus

    You may also want to check that the EnterKeyBehavior and TabKeyBehavior properties of the text box that you want to leave are both set to False.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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] Text Box After press enter i want to select all text of a textbox (userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2017, 01:19 AM
  2. [SOLVED] can vba control "when press enter, selection move direction"
    By mrkhchan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2014, 10:56 AM
  3. Userform - Move to next textbox field by hitting enter instead of
    By TimT in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 11-18-2014, 07:38 PM
  4. [SOLVED] To move cursor to the next row automatically when we enter press
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2013, 09:13 AM
  5. Userform: Pass textbox values to another textbox on button press
    By adjustermn in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2010, 11:19 PM
  6. Press Enter in TextBox
    By d61helix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2005, 11:35 PM
  7. must press enter 2x to move cell focus
    By Lynn in forum Excel General
    Replies: 0
    Last Post: 03-18-2005, 03:06 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