worksheet changes

C

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
 
R

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


CTInt04 said:
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
Click to expand...
another one that could be used.
 
Top