Changing the position of the cursor after data entry.

[Zac]

I know this can be done, but I forget where to go.
Is there a way of having the cell pointer stay in the cell after you enter data?
Rather than have it jump a cell down or a cell to the right.

Thanks
Zac

 

[shades]

CONTROL + ENTER

 

[Von Pookie]

I believe you mean Alt+Enter.

This will put a return in whatever cell you are in instead of moving to the next cell.

 

[Zac]

I disagree.

If you enter data in a cell, and hit Enter,
I want the cursor or pointer to stay in that
cell and not advance to the cell below or
the cell to the right.

I'm writing a macro for the person upstairs.
My keystrokes doesn't move the cell pointer to the cell below or to the right, but theirs does. So when the macro executes on her system, the data ends up in different cells because after she keystrokes data, her pointer jumps to the next cell down.

How do I change her settings to correct that problem?

Zac

 

[shades]

CONTROL + ENTER works for me (Excel 97). After entering data, I hit that combination and the cell remains selected.

ALT + ENTER means inserting a paragraph within the cell.

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-04-08 12:26

 

[shades]

Go to TOOLS > OPTIONS > EDIT tab, then uncheck box "Move Selection after enter"

 

[Jay Petrulis]

On 2002-04-08 12:09, Zac wrote:
I disagree.

If you enter data in a cell, and hit Enter,
I want the cursor or pointer to stay in that
cell and not advance to the cell below or
the cell to the right.

I'm writing a macro for the person upstairs.
My keystrokes doesn't move the cell pointer to the cell below or to the right, but theirs does. So when the macro executes on her system, the data ends up in different cells because after she keystrokes data, her pointer jumps to the next cell down.

How do I change her settings to correct that problem?

Zac

Tools>Options>Edit
Adjust the Move selection after Enter to the direction you want.

Are you using Send Keys in your routine? Post your code so it can be rewritten to eliminate the problem. Your procedure needs to work correctly regardless of the settings.

Others may disagree, but I feel it is best to avoid send keys unless there is no other way to accomplish a task.

Bye,
Jay

 

[Zac]

BINGO. Tools - Options - EDIT....

Thanx

 

[Von Pookie]

On 2002-04-08 12:22, shades wrote:
CONTROL + ENTER works for me (Excel 97). After entering data, I hit that combination and the cell remains selected.

ALT + ENTER means inserting a paragraph within the cell.

Ah, gotcha. I assumed he was just wanting to drop down a line and continue. Sorry!

_________________
Kristy

"There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer
This message was edited by Von Pookie on 2002-04-09 07:44