Différence Target et Activecell

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

    If Target.Address = Range("A1").Address Then
        MsgBox ("solution target")
    End If
    
    
    If ActiveCell.Address = Range("A2").Address Then
        MsgBox ("solution activecell")
    End If

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If Target.Address = Range("A1").Address Then
        MsgBox Target.Address
    End If
    
    If ActiveCell.Address = Range("A1").Address Then
        MsgBox Target.Activate
    End If
End Sub

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

Discussions similaires