moving to specific cells

25 views
Skip to first unread message

Bryce

unread,
Jan 23, 2002, 2:21:36 PM1/23/02
to
Is it possible to designate what cell to move to when you
hit enter. (after putting data into a cell)

David McRitchie

unread,
Jan 23, 2002, 3:51:45 PM1/23/02
to
Hi "Bryce",
Not really, but you can use cell protection to restrict
access to certain cells. You can use an Event macro
to move to another cell after user entry. You might look at
Worksheet Events
http://www.mvps.org/dmcritchie/excel/event.htm
starting at "Worksheet_SelectionChange to prevent entry past a column"
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bryce" <thom...@hotmail.com> wrote ...

L. Howard Kittle

unread,
Jan 23, 2002, 5:29:14 PM1/23/02
to
Hi Bryce,

There are a couple ways to do what I think you are seeking.

If its just across a row, say from B2 to F2 and the next row you
want is B3 to F3, then you can make your first entry in B2 and hit
the Tab to move to C2. Use tab until you are in F2 and after that
entry hit Enter and it will return you to C2. Repeat using Tab
again then Enter for all the rows.

If the cells you want to enter data in are all over the place you
can select them all by holding Ctrl down and click on each cell in
the order you want to enter the data, when all are selected click
back into the cell you want to start in. With the cells still
selected go to the name box and name the range "whatever" and hit
Enter. To enter data in "whatever" click the drop down list on
the name box and click "whatever"? and enter your data in the
first cell and hit Enter twice, Enter will now take you to all the
cells in the order you selected them.

HTH
Regards,
Howard

"Bryce" <thom...@hotmail.com> wrote in message
news:b8dc01c1a443$2d0faa50$37ef2ecf@TKMSFTNGXA13...

David McRitchie

unread,
Jan 24, 2002, 2:17:42 AM1/24/02
to
Hi Howard,
That is neat, never thought of multiple ranges, for a named
range. Works for both TAB and Enter, neat to watch
the selection go across to the right, down, then across
to the left. (wonder if it works in XL95 as well)
A2, C2, E2, G2, F3, D3 B3, A4, C4, E4, G4, A2

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"L. Howard Kittle" <lhki...@attbi.com> wrote in message news:_OG38.1586$T2.1891@rwcrnsc54...

Reply all
Reply to author
Forward
0 new messages