Private Sub Worksheet_Change(ByVal Target As Range)

[Guest]

Specifying Target Not Working...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("i4_Disc") Then
Msgbox “Cell D11 has changed.â€
End If
End Sub

Thanks,
Arturo

 

[Guest]

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$D$11" Then
Msgbox “Cell D11 has changed.â€
End If

http://www.cpearson.com/excel/events.htm

d'oh!