Re: ENTER button

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RagDyer (ragdyer_at_cutoutmsn.com)
Date: 06/08/04 

Date: Mon, 7 Jun 2004 17:41:43 -0700

<<"RagDyer, with default "Down" the cursor normall goes straight
down after entry, not to first column of next row.">>

If you'll re-read my post David, you'll see that I stated, just as the OP
described his use of <Tab>, when you tab after data entry, for however many
entries, and *then* you hit <Enter>, the cursor *will* automatically go to
the *following* row, right *under* where you *started* with your first
<Tab>!

In fact, for this to occur, the default cursor movement *must* be set to
down.

If it's set to default "Up", then the focus will automatically shift to the
starting column, one row above the original first data entry cell. 

-- 
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
"David McRitchie" <dmcritchie@msn.com> wrote in message
news:uPcGt4OTEHA.3596@tk2msftngp13.phx.gbl...
Hi Rawley,
You can use an Event  macro such as the following to make
things easier.
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If Range("b2").Value <> "" Then Exit Sub       'escape clause
   If Target.Column < 6 Then Exit Sub        'okay until column F or later
   On Error Resume Next  'MUST reenable events...
   Application.EnableEvents = False
   ActiveCell.Offset(1, 2 - Target.Column).Select   'return to column B
instead of A of next row
   Application.EnableEvents = True
End Sub
More information on Event macros and for the above macro in
    Worksheet_SelectionChange (#ws_sc)
        Example: Worksheet_SelectionChange to prevent entry past a column
         http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc
be sure to read the top of the article as well.
To install this event macro,  right click on sheetname then view code, and
insert your code.      So if you have a lot of these to do you can actually
change your Enter key to go to the right instead of Down.   Easy enough
to change in your tools, options, Edit.     And this just reminded to
put mine back to "Down" since I was doing this yesterday.
RagDyer,   with default "Down"  the cursor normall goes straight
down after entry, not to first column of next row.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:uXCepOOTEHA.240@TK2MSFTNGP11.phx.gbl...
> You really *don't* have to make *anything*, because that's how it *is*!
>
> Click in a cell and enter data, and then <Tab> to the next cell to enter
> data.
> Keep on entering and tabbing as necessary.
> Then hit <Enter>, and the focus *automatically* moves to the next row,
> directly under the cell where you started your first entry (wherever that
> might have been).
>
> "RAWLEY" <anonymous@discussions.microsoft.com> wrote  ...
> Isn't there a way to make it so that if you're entering data and tabbing
> over several columns as you go, that after you hit ENTER the box moves
down
> one row and to the first column that you began entering data into?
>
> Thanks!
>

Relevant Pages

  • Re: Microsoft Excel
    ... entry, then hit Enter key. ... Using the TAB key only will move across A to G then back to A down one row. ... Then set your ENTER key to move right after entry. ... >first column. ...
    (microsoft.public.excel.misc)
  • Re: How to get WBS code as the first (grey) column in MSP2003?
    ... Rename the table from "Copy of Entry" to a name of your liking. ... Click the Insert Row button and select WBS from the Field Name drop down ... column should now be the first column in the table and should be locked. ...
    (microsoft.public.project)
  • Anyone having trouble with the linking to contacts?
    ... Interestingly the First column is an array with the names of my ... To be able to locate an entry by typing the first few letter ... correct order. ... Is there any way of letting the MBU now about the bug? ...
    (microsoft.public.mac.office.entourage)
  • RE: sumif with similar cells
    ... entry in the first column. ... Gary's Student ... "Mosqui" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Serious Bug using Office 2000 with Project Server 2003 and WSS
    ... entry in the registry that somehow does not know who I am logged in as ... Here is the location of the entry: ... David ... the users Office Profile gets corrupted and each web ...
    (microsoft.public.project.pro_and_server)