+ Reply to Thread
Results 1 to 3 of 3

VBA to move cursor

  1. #1
    Registered User
    Join Date
    10-17-2012
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    7

    Post VBA to move cursor

    I am using excell 2010. The worksheet has values typed into cells and the user needs to click the enter key to move to next cell where data next data is to be entered etc, etc. until the where no need to add values. I would like to be able to move cursor to next cell based on the value that is in the avtive cell rather than use the enter key. eg if you enter a value and that value is a 1 digit value is between 2 and 9 then move to next cell or if a 1 has been entered then a second digit must be added and the enter kety is clicked to move ore could move as with any number between 2 and 9. Hope this is not difficult to understand.
    Thanks for your help
    nzas


    EXAMPLE BELOW
    Cell A1 B1 C1 D1
    Data 2 move 2 move 3 move 1 (would need second digit)
    EG above as numbers entered A1 to C1 would move to left D1 needs a second digit before it could move
    Last edited by nzas; 05-08-2014 at 08:06 PM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to move cursor

    need a sample file with notes
    Last edited by patel45; 05-09-2014 at 05:07 AM.
    If solved remember to mark Thread as solved

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA to move cursor

    I'm not sure that you can easily.

+ 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] Move Cursor to A1
    By Silver in forum Excel General
    Replies: 7
    Last Post: 05-07-2015, 10:27 AM
  2. Move cursor down 2
    By gujugolf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2012, 06:23 PM
  3. [SOLVED] Move cursor to next row
    By Hank in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 04:56 PM
  4. move cursor
    By Peter in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2005, 02:05 PM
  5. Replies: 1
    Last Post: 08-26-2005, 03:05 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