+ Reply to Thread
Results 1 to 2 of 2

Cursor Movement using Criteria

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

    Cursor Movement using Criteria

    Hi
    I found this code on the site that more or less does what I want.
    Rather than using the enter key to move cursor to next cell I want it to move based on a criteria for the data entered ie if cell is =>2 then move to next cell. If the value <1 then there would be a pop up message XXXXXX and would not move until cell update with new value that meets the 1st criteria. when say 9 cells have values entered in the row then the data is copied and pasted to sheet 2 row 1 as new dat added to sheet 1 this would need to have this row inserted for each time sheet 1 had data entered and the data in sheet 1 would be deleted making ready for next lot of data to be added etc, etc until finished the data entry


    Eg values entered in cells a1 TO a9

    data entered 2 (move), data entered 1 (popup) the value is updated to 10 (move), etc etc until A9 is reached then it is copied an pasted to sheet 2.

    VBA Code found I want to update according to above or have a totally new code that will work
    Thanks. I am just starting to use VBA and have little knowledge

    Please Login or Register  to view this content.
    Last edited by nzas; 05-13-2015 at 10:01 PM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: Cursor Movement based on the cells Criteria

    Your thread does not comply with Rule #3.
    Your VBA code should be placed between CODE TAG. See rules for details.
    Your thread can not be answered before you change this.
    Regards
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. code/formula needed for assigning cursor movement to specific cells in unprotected sheet
    By HenrikHagdahl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2013, 05:55 PM
  2. [SOLVED] cursor movement
    By akcommerce in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2013, 06:08 AM
  3. 2010, Cursor movement in locked cells
    By nsv in forum Excel General
    Replies: 0
    Last Post: 03-30-2011, 09:09 AM
  4. controlling cursor movement in unlocked and protected cells
    By thomaskprakash in forum Excel General
    Replies: 1
    Last Post: 09-02-2009, 08:51 AM
  5. Cursor Movement
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2006, 07:55 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