+ Reply to Thread
Results 1 to 4 of 4

Macro to move cursor when cursor is moved to certain column

  1. #1
    Registered User
    Join Date
    12-07-2015
    Location
    st louis
    MS-Off Ver
    2013
    Posts
    10

    Macro to move cursor when cursor is moved to certain column

    I am trying to find a way to have set up my worksheet so that when data is entered via scanning a qr code and i get to a certain column the cursor would move back to column A. For example, someone comes up with a name badge with a qr code on it i will scan that data and have it populate into column A2, I will take a tablet that has a qr code on it and scan that data into column B2 and after that scan i want the cursor to move to A3 and for that to continue. Any help would be greatly appreciated. excel help.PNG

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Macro to move cursor when cursor is moved to certain column

    Right-click on tab with your sheet name
    select View code from pop-up menu
    in code window paste:
    Please Login or Register  to view this content.
    return to your workbook and see if it works as expected
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-07-2015
    Location
    st louis
    MS-Off Ver
    2013
    Posts
    10

    Red face Re: Macro to move cursor when cursor is moved to certain column

    This is working just the way i need it to, thanks Kaper it's really really appreciated!

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Macro to move cursor when cursor is moved to certain column

    Glad to hear that, and thanks for the reputation. Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Move cursor to intersection of row and column
    By shawnvon in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-20-2015, 12:03 PM
  2. [SOLVED] Macro to move cursor to column containing current date at worksheet activation
    By Snoddas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-03-2013, 05:40 AM
  3. Move Cursor from one column to another
    By wish2excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2010, 02:52 PM
  4. Event-Macro to move the cursor
    By ElmerS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2009, 03:09 PM
  5. cursor highlights entire doc when moved
    By mickeymny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2006, 01:35 PM
  6. Replies: 1
    Last Post: 08-26-2005, 03:05 PM
  7. move cursor to 4th column with one press of tab key?
    By Naveed Ahmad Purewal in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-14-2005, 12:06 AM

Tags for this Thread

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