cell change
What would you like to happen?
The code executes when any cell on the sheet changes but your don't tell it
to do anything. Here's a guess that does something and may get you going:-
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo stoppit
Application.EnableEvents = False
For Each c In Range("drw1inforng")
If c.Value < "" Then
MsgBox c.Value
End If
Next
stoppit:
Application.EnableEvents = True
End Sub
Mike
"ranswert" wrote:
I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("drw1inforng")
If .Value < "" Then
MsgBox ("")
End If
End With
stoppit:
Application.EnableEvents = True
End Sub
'drw1inforng' is a named range on my sheet. When I make a change in this
range, nothing happens. What am I doing wrong here?
Thanks
|