Home » Forums » Open Source Learning Center » Question and Answer

OnEntry, Worksheets_change question

Submitted by gpelletier on 15 August, 2012 - 17:12

Hello,

Is there a way to narrow OnEntry or Worksheets_change, not to a sheet but a range in that sheet.
To avoid to much back an foward to the code?

Thank you!

‹ Simple Spread Sheet Excel Nested IF Functions ›
»
Nick's picture

restrict events to particular range

Submitted by Nick on 16 August, 2012 - 09:23.
Private Sub Worksheet_Change(ByVal Target As Range)
 
' look to see if the range that's being changed is within the desired range
    Set myRange = Intersect(Target, Range("A1:A10"))
 
    If myRange Is Nothing Then
' if it isn't, do nothing
        MsgBox "Outside range: do nothing"
        Exit Sub
    Else
' if it is, do what you need to do
        MsgBox "Inside range"
        Exit Sub
    End If
 
End Sub
»

Restric event to particular range

Submitted by gpelletier on 16 August, 2012 - 22:41.

Thank you,

I was doing it in a less elegant way ...

»