+ Reply to Thread
Results 1 to 5 of 5

To move cursor to the next row automatically when we enter press

  1. #1
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    To move cursor to the next row automatically when we enter press

    Hai dudes

    Once again nice to meet you through this post guys

    plz help me to solve my problem

    ..is there any possibility of moving the cursor the next line (ex in my case when i reach the cell L3 right from C3 ,and when i press enter it should take the cursor to the next row c4 if i enter alphabets or word in L3,

    In case if i enter number in L3 ,then the cursor should moves up to M3 ,then when i press enter in Cell M3 it should move to Cell C4

    Thank you very much

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: To move cursor to the next row automatically when we enter press

    In your worksheet module, in my case I used Sheet1, place the following code
    Please Login or Register  to view this content.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: To move cursor to the next row automatically when we enter press

    Hai this is a real magic Mordred You are really great ...Hats off to you
    it is perfectly working .Tomrw when i take this to my office everybody will be excited. I REQUEST EVERY ONE WHO VIEW THIS POST HAS TO TRY IN THEIR EXCELL and experience what i felt

    Thank you very very much
    Narayanan

  4. #4
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: To move cursor to the next row automatically when we enter press

    Thanks catchnanan, it really wasn't much. Take all the credit for it in your office if it means good for you. Thanks for the rep too.

  5. #5
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: To move cursor to the next row automatically when we enter press

    Hello Mordred,
    What a excellent creation! Keep it on.

    Mukesh

+ 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. How to press enter automatically when opening workbook
    By kummakki in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2012, 05:00 AM
  2. Replies: 1
    Last Post: 08-26-2005, 03:05 PM
  3. move cursor to 4th column with one press of tab key?
    By Naveed Ahmad Purewal in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-14-2005, 12:06 AM
  4. Cursor not to move when hitting the enter key
    By Alex Martinez in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2005, 01:06 AM
  5. [SOLVED] 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