+ Reply to Thread
Results 1 to 2 of 2

Specific Range? Macros?... I don't know what area I am looking for this answer in....

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Specific Range? Macros?... I don't know what area I am looking for this answer in....

    So, I have created a workbook that I am trying to get right. My question is, if I want to only be able to put data into a specific range( say A4 to M16) and I don't want to be able to enter data in anything outside of that area. How would I keep someone from doing that. Essentially, I want to start at A4 and be able to TAB all the way over to M4, and then instead of entering down to A5, I want the spreadsheet to "know" that I don't want data in N4 and instead TAB over to A5. I know this works, because I use a spreadsheet that does it every day. Where should I look for the answer, by recording a Macro? or by locking a portion of the spreadsheet? Everything I have tried doesn't work. So, I am sure I am screwing up somewhere. Thanks for any help.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Specific Range? Macros?... I don't know what area I am looking for this answer in....

    Try this in a worksheet change event:
    (note: Taken from StackOverflow site) You will have to build this out to Column M.

    If you type anywhere in Col A, the selection will move to Col B.
    If you type anywhere in Col B, the selection will move to Col C.
    If you type anywhere in Col C, the selection will move back to Col A (Next Line).
    Code: This goes in the relevant sheet code area.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 4
    Last Post: 08-26-2014, 02:44 PM
  2. [b]clear specific or range of cells before macros' run[/b]
    By chergian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 11:21 PM
  3. [SOLVED] How to create a macros that will name a range taking the value of a specific cell?
    By erkamu in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-05-2014, 07:12 AM
  4. VBA to copy unique range to specific range area
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2013, 03:53 PM
  5. [SOLVED] Consolidation Macro with specific range/area of cells
    By acasas44 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-23-2013, 10:35 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