WorkSheet_Change not updating

  • When you delete or insert a row (right click the the row #s on the left before the first column):

    Sub WorkSheet_Change(Byval Target As Range)
    'code
    End Sub


    does not detect that insert or delete row so nothing changes and Access is not updated.


    Is there some way of detecting when the insert row or delete row has been activated to do something that will make WorkSheet_Change notice.

  • Re: WorkSheet_Change not updating


    You have change a cell not a whole row or something else.


    I have put in "Sheet1" in VBA it just:


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    MsgBox ("InsertOrDelete")
    End Sub


    and nothing happens when I right click on the row #s just to the right of columnA and Select "Insert".


    You try.

  • Re: WorkSheet_Change not updating


    Then you got:


    Quote

    ("InsertOrDelete")


    or something like that when you execute row delete or insert.


    or where am I going wrong is it with the whole thing.

  • Re: WorkSheet_Change not updating


    I didn't get that because there was nothing like that in the code I used which was the code you posted originally.


    If I used the code you just posted then I would get the message box.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!