Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
I would like to hit the enter key and have the worksheet insert a blank line
and move to the next line. How do I do that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
Hi Storm2
what every single time you ever press the enter key in excel?!? do you want the new line insert above or below the current line, so if you're on row 11 do you want the blank line to push the 11 to row 12 or to be inserted under the 11 as a new 12 and then where do you want the cursor to actually end up? Cheers JulieD "Storm2" wrote in message ... I would like to hit the enter key and have the worksheet insert a blank line and move to the next line. How do I do that? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
Hi Storm,
As Julie pointed out, kind of ambiguous how you'd be able to do anything if you got what you actually asked for. Normally the Enter goes down though you can make it go across. You can use the TAB key to go across to the right. See if the following would be what you really wanted. Worksheet_SelectionChange (#ws_sc) Worksheet_SelectionChange to prevent entry past a column http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc The purpose of this macro is that the cursor hits a brick wall at column D (col 4) and returns to the beginning (Col A) of the next row. Use the TAB key to go to next cell. No cell protection or validation is required for this macro. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.column < 4 then exit sub On error resume next 'MUST reenable events... Application.EnableEvents = False ActiveCell.Offset(1, 1 - Target.Column).Select Application.EnableEvents = True End Sub To install right click on the worksheet tab, view code, insert the above macro. -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JulieD" wrote in message ... Hi Storm2 what every single time you ever press the enter key in excel?!? do you want the new line insert above or below the current line, so if you're on row 11 do you want the blank line to push the 11 to row 12 or to be inserted under the 11 as a new 12 and then where do you want the cursor to actually end up? Cheers JulieD "Storm2" wrote in message ... I would like to hit the enter key and have the worksheet insert a blank line and move to the next line. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Keyboard shortcuts | Excel Discussion (Misc queries) | |||
Keyboard shortcuts | Excel Discussion (Misc queries) | |||
Keyboard Shortcuts | Excel Programming |