MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Carriage Return" Macro


Posted by Robert on January 25, 2002 12:32 PM

Is there a way to go to a designated cell after hitting return? After entering data in G8, can I set it to automatically go to A9? Any help would be appreciated.


Posted by Juan Pablo G. on January 25, 2002 12:43 PM

Are you trying to do something like, return to column A after entering something in Column G ?, like a carriage return as you sayed ?

Juan Pablo G.

Posted by Robert on January 25, 2002 12:45 PM

Re:

That is exactly what I want to do?

Posted by Robert on January 25, 2002 12:47 PM

Re:

Posted by Juan Pablo G. on January 25, 2002 12:52 PM

Re:

Put this in the Sheet's module

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 7 Then Cells(Target.Row + 1, 1).Select
End Sub

Juan Pablo G.

Posted by Robert on January 25, 2002 12:58 PM

Thank you

Thank you for the assistance.