Event Procedure - Data Validation List
this is standard event:
in the VBA editor
in the sheet's code
use the
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
'event
inside it, you can make a
if not ( intersect( Me.Range("A1:A2"),Target) is nothing) then
' ok my cells
end if
because Target is the changed cell
(something else as been entered inside it)
|