Excel: Change Event based on Defined Name

[gapa]

Dear All,

Is there a way in Excel to trigger an event change based on "Defined name" ?

I.e if I define cell A1 as "Test", how do I change the code so that it will trigger ?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Test Then << Doesn't work
Call Page1.Booking_Type
End If
End Sub

Thanks

 

[cmhoz]

Hi gapa -

You need to use 'not intersect' if you have a range (even if the range is only 1 cell, once it has a name it's a range)...

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("Test ")) Is Nothing Then
Call Page1.Booking_Type
End If
End Sub

 

[Sandeep Warrier]

Or,

you could also try

If Target.Name = "Test" Then

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">