+ Reply to Thread
Results 1 to 5 of 5

Navigate using special Enter

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Navigate using special Enter

    Hello
    I want the Enter key to navigate like that
    If I were in A1 then when pressing Enter to move to B1 and when pressing again moving to C1 till F1 ..
    After this point in F1 to move to B2 and C2 and so on
    Hope it's clear

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Navigate using special Enter

    Hi,

    Put this code in ThisWorkbook module :
    Please Login or Register  to view this content.
    Put this code in Normal module :
    Please Login or Register  to view this content.
    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,985

    Re: Navigate using special Enter

    May I ask why, and why column A is skipped after row 1?
    Everyone who confuses correlation and causation ends up dead.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Navigate using special Enter

    Thanks a lot Mr. karedog
    Masterpiece

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Navigate using special Enter

    You are welcome, glad I can help.

    Regards

+ 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] Allow user to only enter Text in a cell - no special characters
    By VBA FTW in forum Excel General
    Replies: 3
    Last Post: 12-27-2013, 11:02 AM
  2. how to re-navigate using new url
    By gochel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 09:16 AM
  3. Navigate to sheet via VBA
    By ola7mat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2012, 05:13 PM
  4. navigate between worksheets
    By T. Grindlay in forum Excel General
    Replies: 10
    Last Post: 02-08-2012, 07:39 AM
  5. Excel vba to navigate around a PDF
    By dbruby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2012, 10:17 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