+ Reply to Thread
Results 1 to 2 of 2

Cursor Movement using Criteria

  1. #1
    Registered User
    Join Date
    New Zealand
    MS-Off Ver
    Excel 2010

    Cursor Movement using Criteria

    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
    MS-Off Ver
    Excel 2021

    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.
    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


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