controlling excel input move cursor right, then down

**lippywon** · 01-12-2011, 04:37 PM

I am a new vba programmer, and not very good yet. I am trying to make an excel2010 worksheet code that will allow me to input data into a highlighted cell and after I hit return, the highlight should move to the cell to the right, then after hitting return in that cell I want the cursor to move down a row and back 1 cell, then repeat....I've tried if/then loops, and for loops, but can't figure it out. I can get the input to move right by using Target.Offset(0, 1).Select

**TMS** · 01-12-2011, 07:31 PM

In the worksheet module, try something like:

Please Login or Register  to view this content.

Regards

**lippywon** · 01-12-2011, 07:42 PM

TM Shucks. THANK YOU! Brilliant! (can I keep you on retainer?)
thanks,

...Lippy!

**TMS** · 01-13-2011, 03:46 AM

You're welcome. Thanks for the feedback.

**trc310** · 06-16-2012, 08:52 PM

Originally Posted by TMShucks

In the worksheet module, try something like:

Please Login or Register  to view this content.

Regards

I'm new to Excel and ran across this excellent solution for getting the cursor to move right and down. My question is how do you get it to work for three or four columns across, and then back to the beginning column? This presumes that each row will begin at column A.

Thanks in advance.

trc310

**arlu1201** · 06-17-2012, 03:17 AM

Trc310,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.