Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
"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.
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: "Carriage Return" Macro
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.
Re:
Posted by Robert on January 25, 2002 12:45 PM
That is exactly what I want to do?
Re:
Posted by Robert on January 25, 2002 12:47 PM
Re:
Posted by Juan Pablo G. on January 25, 2002 12:52 PM
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.
Thank you
Posted by Robert on January 25, 2002 12:58 PM
Thank you for the assistance.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.