Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Data Entry Macro

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a question that I am pretty sure has been answered before. I am entering data in a spreadsheet and want to minimize the number of keystrokes. Now here is my problem:
    After I enter the data in cell G6, I want the selection to automatically go to cell A7. What kind of macro do I need to put there?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    You could actually use Sheet Protection to do this. The steps are:

    Highlight the data entry range (columns A-G). Format cells, Protection tab, then unlock the cells. Then when you get into a data entry mood go to tools/protection/protect sheet (defaults).

    While the sheet is protected you can only enter data into unlocked cells. The good part is that you can quickly move through the cells by hitting TAB to move to the right or to a new record.

    Hope that helps,
    Adam

  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another option is to use this code in your worksheet module (right click on sheet tab, left click on View Code, and paste this in):

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$G$6" Then Exit Sub
    [A7].Select
    End Sub

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •