worksheet changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top