I just seen there is Application.DataEntryMode.
Never used it, but you could maybe combine that with the Worksheet-Change
event.

NickHK

"JR Hester" wrote in message
...
Totally new to macros and VBA, but may need then to accomplish a task.

Need to direct data entry into specific cell locations in Excel 2000.
Already have unlocked cells and protected worksheet. Need to find a way to
do
something like this:
go to B2 on open sheet
accept data entry
Go to C4, accept data
Go to E4, accept input
and so and so on

I used the record macro process, but I can't find a way to cause the macro
to pause for input, between the go to commands. Therefore the result is
that
It goes straight to the ending location!

I know it's do-able, just don't understand how! Any and all pointers
appreciated!

Thanks in advance