worksheet changes

[CTInt04]

hello,

how do i get the worksheet_change function to only activate on certain cells. if not with this function can you give me hints on another one that could be used.

thanks for your help,

CTInt04

 

[Ron de Bruin]

Hi CTInt04

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A1:A20"), Target) Is Nothing Then
MsgBox ""
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl

hello,

how do i get the worksheet_change function to only activate on certain cells. if not with this function can you give me hints on

another one that could be used.