|
Need to insert row with enter key
My boss is not very computer literate and in order for him to use the
spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
piece of cake. Just put it in a worksheet_change event. Right click sheet
tabview codeinsert thismodify to suitSAVE . Now when you change something in col A a row will be inserted moving that data down one leaving you the same row on which to type again. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
If you mean a new line in the same cell tell him to use Alt + Enter otherwise
enter should go to the cell under is it is selected under toolsoptionsedit and move selection after enter down Regards, Peo Sjoblom "AimzG8Rfan" wrote: My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
I'm not a VBS coder but understand inserting your code. Could you tell me
what exactly I need to modify in that code to make it work with mine? "Don Guillett" wrote: piece of cake. Just put it in a worksheet_change event. Right click sheet tabview codeinsert thismodify to suitSAVE . Now when you change something in col A a row will be inserted moving that data down one leaving you the same row on which to type again. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
Didn't work for me yesterday so thought I missed something. Working today
though! Thanks for your help. "Don Guillett" wrote: I thought it was pretty self-explanatory. Read it again and try it.... -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... I'm not a VBS coder but understand inserting your code. Could you tell me what exactly I need to modify in that code to make it work with mine? "Don Guillett" wrote: piece of cake. Just put it in a worksheet_change event. Right click sheet tabview codeinsert thismodify to suitSAVE . Now when you change something in col A a row will be inserted moving that data down one leaving you the same row on which to type again. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
I take it back, it's not working correctly. Pressing enter causes it to
instert over 200 rows instead of just one. I pasted your formula exactly as you wrote it. Can you help? "AimzG8Rfan" wrote: Didn't work for me yesterday so thought I missed something. Working today though! Thanks for your help. "Don Guillett" wrote: I thought it was pretty self-explanatory. Read it again and try it.... -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... I'm not a VBS coder but understand inserting your code. Could you tell me what exactly I need to modify in that code to make it work with mine? "Don Guillett" wrote: piece of cake. Just put it in a worksheet_change event. Right click sheet tabview codeinsert thismodify to suitSAVE . Now when you change something in col A a row will be inserted moving that data down one leaving you the same row on which to type again. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
I just re-tested in xl2002 with the code in a worksheet module (not a
regular module and not ThisWorkbook). When I enter anything in col A a row is inserted....... -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... I take it back, it's not working correctly. Pressing enter causes it to instert over 200 rows instead of just one. I pasted your formula exactly as you wrote it. Can you help? "AimzG8Rfan" wrote: Didn't work for me yesterday so thought I missed something. Working today though! Thanks for your help. "Don Guillett" wrote: I thought it was pretty self-explanatory. Read it again and try it.... -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... I'm not a VBS coder but understand inserting your code. Could you tell me what exactly I need to modify in that code to make it work with mine? "Don Guillett" wrote: piece of cake. Just put it in a worksheet_change event. Right click sheet tabview codeinsert thismodify to suitSAVE . Now when you change something in col A a row will be inserted moving that data down one leaving you the same row on which to type again. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett SalesAid Software "AimzG8Rfan" wrote in message ... My boss is not very computer literate and in order for him to use the spreadsheet I created for tracking jobs, he "must" be able to insert a row by hitting the enter key. Basically, he wants to just type on a line, hit enter, and be on the next line to type something -- like Word does. Any ideas?? |
| All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com