+ Reply to Thread
Results 1 to 7 of 7

Automatically Move Cursor After Keyng Data

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    82

    Automatically Move Cursor After Keyng Data

    Is there a way to have the cursor move to next cell on the right after entering data? I am using Excel 7 and 10.

    I have a row where I enter a number (minimum is 1 and maximum is 29) in a cell and then continue to the next cell on the right. I repeat this over a row of 18 cells. Then, I want to jump down to the next row (actually two rows down), and repeat the process. Then after I enter data in that row using 18 cells, I have to jump down 4 rows and repeat the process.

    Simply put, I want to have the cursor move without hitting enter or arrow keys, to next cell to the right. I currently have the "enter" key set to move right in the options.

    Row D8 thru L8 and then P8 thru X8
    Row D10 thru L10 and then P10 thru X10
    Row D14 thru L14 and then P14 thru X14
    Row D16 thru L16 and then P16 thru X16

    I have to repeat this process on a total of 7 identical sheets. And I am trying to avoid using the enter and/or arrow keys as much as possible to save time.

    I'm guessing this may be a macro question. Since I don't have much experience with macros, I'm not sure.

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Automatically Move Cursor After Keyng Data

    Lock cells you don't want users entering data in, the protect the sheet and remove the ability select locked cells.

    See the cell formatting dialog for cell protection
    See the Reviewing tab for locking the sheet.

  3. #3
    Registered User
    Join Date
    07-07-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: Automatically Move Cursor After Keyng Data

    I had already done the protect sheet with the locked cells procedure.

    It works fine when I use the enter key. I am wondering if there is a code that will move the cursor after the data is keyed, without using the enter or arrow keys.

    Thanks

  4. #4
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Automatically Move Cursor After Keyng Data

    If there was a keypress event for worksheets, I'd say yes, but according to MSDN there isn't. Data isn't updated until pressing enter or tab, so the worksheet_change event won't work either. Anyone else have an idea?

  5. #5
    Registered User
    Join Date
    07-07-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: Automatically Move Cursor After Keyng Data

    Quote Originally Posted by tlafferty View Post
    If there was a keypress event for worksheets, I'd say yes, but according to MSDN there isn't. Data isn't updated until pressing enter or tab, so the worksheet_change event won't work either. Anyone else have an idea?
    Yeah, that is what I thought.

    It seems to me, that many years ago when I worked with Access to build a data base, it offered the option to move the cursor after a predetermined criteria was met to fill a cell.

    Like entering "01", but not "1". That was over fifteen years ago since I tried working with Access. I would be lost with it too now.

    I'll leave the post up for a while to see if anyone else has an idea.

    Thanks tlafferty for looking into it.

  6. #6
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Automatically Move Cursor After Keyng Data

    If locking down the worksheet will allow you to navigate successfully, why not develop a user form to populate the sheet? Text controls can automatically move to the next field when a certain length of characters is input.

  7. #7
    Registered User
    Join Date
    07-07-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: Automatically Move Cursor After Keyng Data

    Quote Originally Posted by tlafferty View Post
    If locking down the worksheet will allow you to navigate successfully, why not develop a user form to populate the sheet? Text controls can automatically move to the next field when a certain length of characters is input.
    I just looked at your suggestion's work that would be involved to create. I think just using the enter or tab key would be less time consuming compared to the time it would take to develop the user form.

    Thanks for the suggestion.

+ 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