Don't think you can do it with a Return/Enter, but maybe
one of the VB experts can help.
You can simplify the process a bit by doing two things.
First, set your cursor response option
(Tools/Options/Edit) to move Down when you do hit Enter.
Second, add the Insert Row button to one of your visible
tool bars. Then, when you hit Enter, the cursor moves to
the next row, and all you have to do it click the Insert
Row tool icon.
HTH
-----Original Message-----
is there a way so that if i press return a new row is
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.