How to trigger a macro on a worksheet on the event of user-input?

[fiven]

Hi,

I want to trigger a macro on a worksheet when user inputs new rows, but i don't know which event to use

If you have any tip, please help me.

Thanx in advance !

[crispbd]

Dim Currentrow As Integer

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row <> Currentrow Then Call mymacro(Target.Row)

End Sub
Function mymacro(ByVal newRow As Integer)
MsgBox "new row"
Currentrow = newRow
End Function

[fiven]

Thank you very much !

By your suggestion, i can solve it now .

Cheers !