Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row method (?)
is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted? ex: if the user just inserted a new row... do this... (msgbox (you just inserted row(s)...) thanks in advance, -mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row method (?)
right click on the sheet tab and select view code
paste in this code: Private Sub Worksheet_Change(ByVal Target As Range) MsgBox Target.Address End Sub Now go back to the sheet and Insert a row Delete a row select a row and hit the delete key to clear the values. change will tell you that something has happened, but it isn't going to tell you specifically that it is an insert or a delete - you would to code in more knowledge of your sheet to discern whether a row insertion or deletion triggered the change event. -- Regards, Tom Ogilvy "mark kubicki" wrote: is there a way to initiate code if a row has been inserted into the worksheet, and to tell where the row(s) were inserted? ex: if the user just inserted a new row... do this... (msgbox (you just inserted row(s)...) thanks in advance, -mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row method (?)
and just to Add, in xl97, if I am remembering correctly, the change event is
triggered on a insertion. -- Regards, Tom Ogilvy "mark kubicki" wrote: is there a way to initiate code if a row has been inserted into the worksheet, and to tell where the row(s) were inserted? ex: if the user just inserted a new row... do this... (msgbox (you just inserted row(s)...) thanks in advance, -mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row method (?)
this is good (thanks)
i'm familiar enough withthe change event... any suggestins about what the could be coded in to discern the insert/delete and the row(s) it occurred in? would it make sense to create an array of cell values and addresses, and then comapre it to the same array generated prior to the change; note the differences and ... -mark "Tom Ogilvy" wrote in message ... right click on the sheet tab and select view code paste in this code: Private Sub Worksheet_Change(ByVal Target As Range) MsgBox Target.Address End Sub Now go back to the sheet and Insert a row Delete a row select a row and hit the delete key to clear the values. change will tell you that something has happened, but it isn't going to tell you specifically that it is an insert or a delete - you would to code in more knowledge of your sheet to discern whether a row insertion or deletion triggered the change event. -- Regards, Tom Ogilvy "mark kubicki" wrote: is there a way to initiate code if a row has been inserted into the worksheet, and to tell where the row(s) were inserted? ex: if the user just inserted a new row... do this... (msgbox (you just inserted row(s)...) thanks in advance, -mark |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row method (?)
There is no Universal Truth here. Whatever makes sense to you makes sense.
You know what your worksheets look like and what your users may or may not do. but yes, the basic approach is probably one of before and after comparisons. Maybe add in a little bit of size to the sheet and put a distinct value below and to the right of actual used range, then check its row and column location each time against what it used to be. Set the scrollarea and use the selectionchange event to further prevent selection in this area. -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "mark kubicki" wrote: this is good (thanks) i'm familiar enough withthe change event... any suggestins about what the could be coded in to discern the insert/delete and the row(s) it occurred in? would it make sense to create an array of cell values and addresses, and then comapre it to the same array generated prior to the change; note the differences and ... -mark "Tom Ogilvy" wrote in message ... right click on the sheet tab and select view code paste in this code: Private Sub Worksheet_Change(ByVal Target As Range) MsgBox Target.Address End Sub Now go back to the sheet and Insert a row Delete a row select a row and hit the delete key to clear the values. change will tell you that something has happened, but it isn't going to tell you specifically that it is an insert or a delete - you would to code in more knowledge of your sheet to discern whether a row insertion or deletion triggered the change event. -- Regards, Tom Ogilvy "mark kubicki" wrote: is there a way to initiate code if a row has been inserted into the worksheet, and to tell where the row(s) were inserted? ex: if the user just inserted a new row... do this... (msgbox (you just inserted row(s)...) thanks in advance, -mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
Any method available to insert pic into comment box?? | Excel Discussion (Misc queries) | |||
Insert method of range class failed | Excel Programming | |||
Insert method of range class failed | Excel Programming |