| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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?? |
|
#2
|
|||
|
|||
|
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?? |
|
#3
|
|||
|
|||
|
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?? |
|
#4
|
|||
|
|||
|
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?? |
|
#6
|
|||
|
|||
|
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?? |
|
#7
|
|||
|
|||
|
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?? |
|
#8
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change something in Excel to automatically insert an equa. | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| how to insert row automatically after hitting enter at the end of. | Excel Worksheet Functions | |||
Linear Mode
