| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel2007 Stipulate where cursor goes when Enter Key pressed
I would prefer event code so's I didn't have to click a button
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 1 Then With Target .Offset(1, -1).Select End With End If End Sub Goes into the sheet module. Requires that something has been entered in the activecell then ENTER key hit. Gord On Mon, 9 Mar 2009 14:24:07 -0700, RonG wrote: Thanks Gord, you've confirmed my thoughts. A macro with a button on the spreadsheet should do the trick. Thanks buddy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit Enter - cursor to beginning of next row? | Excel Discussion (Misc queries) | |||
| How do I select the column cursor jumps to when I hit end enter? | Excel Worksheet Functions | |||
| Moving between cells when enter is pressed | Excel Discussion (Misc queries) | |||
| Enter button jumps to next cell each time its pressed!!!! | Excel Discussion (Misc queries) | |||
| Cursor not to move when hitting the enter key | Excel Worksheet Functions | |||
Threaded Mode
