Add to worksheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
'add code here or call macro
'change $B$1 to suit
End if
End Sub

Hth,
Merjet

is it possible to have multiple ifs to trigger event I am having no luck
Thanks

"merjet" wrote:

Add to worksheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
'add code here or call macro
'change $B$1 to suit
End if
End Sub

Hth,
Merjet

Yes, there can be 1 trigger.

Merjet

Not sure if I am going right way. For some reason my trigger in a column is
not triggering the call.

If Target.Column = 9 And Target.Value 1 And IsNumeric(Target.Value) Then _
Call CopyMailE(Target)
Have two other procedures that work fine on column 12 different values for
trigger
Just for good measure will add copymaile

Public Sub CopyMailE(ByVal Target As Range)
Dim wksSummary As Worksheet
Dim rngPaste As Range
Set wksSummary = Sheets("Maile")
Set rngPaste = wksSummary.Cells(65536, "A").End(xlUp).Offset(1, 0)
Application.EnableEvents = False
Target.Parent.Cells(Target.Row, 1).Resize(5, 9).Copy _
Destination:=rngPaste
Application.EnableEvents = True
End Sub
Help greatly appreciated
Thanks


"merjet" wrote:

Yes, there can be 1 trigger.

Merjet

got it
thanks

"merjet" wrote:

Yes, there can be 1 trigger.

Merjet

I miss phrased my question. What I a want is.
if column 11 = 10 and column 2 =2 then call procedure
Have tried to do this in procedure with no luck. So now will use two diff
procedures if I can control action of trigger by two cells.
I do use two triggers in one row thanks to your responce.
Thanks


"merjet" wrote:

Yes, there can be 1 trigger.

Merjet

I don't see the original thread ( PLEASE stay in original) so I will try to
guess.
if cells(target.row,11)=10 AND cells(target.row,2)=2 then call mymacro
--
Don Guillett
SalesAid Software

"Curt" wrote in message
...
I miss phrased my question. What I a want is.
if column 11 = 10 and column 2 =2 then call procedure
Have tried to do this in procedure with no luck. So now will use two diff
procedures if I can control action of trigger by two cells.
I do use two triggers in one row thanks to your responce.
Thanks


"merjet" wrote:

Yes, there can be 1 trigger.

Merjet