Results 1 to 29 of 29

Stopping (IF - Then) code from jumping to another cell after enter, tab or right arrow?

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Stopping (IF - Then) code from jumping to another cell after enter, tab or right arrow?

    The problem I'm having is the code works great, but it won't stop jumping five rows up after hitting enter, tab, or right arrow after last entry in cell (D14) it keep jumping up to cell (E7). I need the code to stop completely after I hit enter when putting data in cell (D14) and the user can choose which method they choose to keep going across to the right of cell (D14) of their choosing. See code below, thanks!

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$E$4" Then
     Range("E11").Select
    End If
    If Target.Address = "$E$11" Then
     Range("J2").Select
    End If
    If Target.Address = "$J$2" Then
     Range("J3").Select
    End If
    If Target.Address = "$J$3" Then
     Range("J4").Select
    End If
    If Target.Address = "$J$4" Then
     Range("J6").Select
    End If
    If Target.Address = "$J$6" Then
     Range("D14").Select
    End If
    If Not Intersect(Target, Range("D14")) Is Nothing Then
     
      Exit Sub
          
       End If
    End Sub
    Last edited by ElmerFud; 07-30-2015 at 03:56 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to push painted cell using the arrow keys or shape-arrow in Excel - VBA-Offset?
    By Dumy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-04-2015, 05:05 AM
  2. Code for Jumping to a sheet needed
    By charles.2345 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2011, 01:04 AM
  3. Auto Jumping to next cell without pressing enter
    By Steve Brown in forum Excel General
    Replies: 1
    Last Post: 01-21-2008, 02:47 PM
  4. My code is jumping workbooks
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2007, 02:17 PM
  5. [SOLVED] Is it possible to set the enter and arrow keys to skip locked cel
    By Barron in forum Excel General
    Replies: 2
    Last Post: 03-18-2006, 04:10 AM
  6. [SOLVED] how do I move cursor without tab, enter or arrow in Excel
    By jlseagull in forum Excel General
    Replies: 1
    Last Post: 07-15-2005, 11:05 PM
  7. [SOLVED] when I protect my sheet enter tab, & arrow keys dont work...
    By greg in forum Excel General
    Replies: 0
    Last Post: 05-25-2005, 11:06 AM

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