I want to enter a value from the keyboard into a column; move the cursor
to the right one column, enter another value from the keyboard; move the
cursor to the right again, enter the third and final value; move the
cursor down one then over to the left to the beginning column and do it
all over again.

A simpler way to state the problem may be: "How do I get the macro to
"prompt" me for keyboard entry of the value I want entered?"


--
sva3
------------------------------------------------------------------------
sva3's Profile: http://www.excelforum.com/member.php...o&userid=26451
View this thread: http://www.excelforum.com/showthread...hreadid=397195

Easier would be to highlight the range of cells where you want to make
entries.

then use the tab key instead of the enter key after you make your entry and
you will move within the selection as you describe.

--
Regards,
Tom Ogilvy

"sva3" wrote in message
...

I want to enter a value from the keyboard into a column; move the cursor
to the right one column, enter another value from the keyboard; move the
cursor to the right again, enter the third and final value; move the
cursor down one then over to the left to the beginning column and do it
all over again.

A simpler way to state the problem may be: "How do I get the macro to
"prompt" me for keyboard entry of the value I want entered?"


--
sva3
------------------------------------------------------------------------
sva3's Profile:
http://www.excelforum.com/member.php...o&userid=26451
View this thread: http://www.excelforum.com/showthread...hreadid=397195