View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
abcd[_3_] abcd[_3_] is offline
external usenet poster
 
Posts: 17
Default 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)