+ Reply to Thread
Results 1 to 8 of 8

Cursor Position after enter

  1. #1
    Registered User
    Join Date
    01-26-2009
    Location
    Kent
    MS-Off Ver
    Excel 2007
    Posts
    11

    Cursor Position after enter

    I'm trying to make a simple dart board scorer for my friends laptop to use at
    home, fairly simple, but how can I set it up so after a score is entered in
    position 1, then hit enter the cursor moves automatically to position 2, then enter, then position 3, then enter, position 4, enter, etc etc.
    I am only an intermadiate user, so please explain carefully.
    Thanks to all.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Cursor Position after enter

    Unlock those cells, protect the worksheet not allowing selection of unlocked cells, and set Move Selection after Enter Direction to Right
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Cursor Position after enter

    Please see the attachment. The code is an event driven macro which you will find on the Sheet1 tab in the VBA editor.

    I've taken the liberty of making the formulae for counting the remaining score a bit neater by using a sum function over all the rows in the sheet. (Might be a good idea if your players are as bad at darts as I am. )
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,963

    Re: Cursor Position after enter

    deleted; already solved
    Last edited by protonLeah; 02-01-2009 at 03:08 PM.
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    01-26-2009
    Location
    Kent
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Cursor Position after enter

    Have you viewed attached sheet to see where the positions are ?
    postion 1 to 2 equals direction right ( 2 places ), then from position 2 to position 3 equals down 1 place and left 2 places.
    I think you need to view to understand.

  6. #6
    Registered User
    Join Date
    01-26-2009
    Location
    Kent
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Cursor Position after enter

    I had a look at code but to be honest, I dont think I understand it, but its works great, so thanks a lot.

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Cursor Position after enter

    I think you need to view to understand.
    If that's addressed to me, I did view it, did what I suggested you should do, and verified that it works.

  8. #8
    Registered User
    Join Date
    01-26-2009
    Location
    Kent
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Cursor Position after enter

    I'm sorry, I did not mean to sound rude but I obviously did not quite follow what you was saying to do.
    Thanks for all the help.

+ 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