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 !
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 !
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
Thank you very much !
By your suggestion, i can solve it now .
Cheers !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks