Hello there,
It is my first post, so I will like to say thanks to everyone who has helped somebody in one way or the other on this forum. I have been able to work around some vba issues just by reading the answers from other threads.
I am new to vba programming in excel so my question might look simple but I have battled with it for hours, SOS any one.
the code I created, works well and triggers for individual cells in the range but prematurely, instead I want to be able to click a button
after I have inputed all the data so that the event handler will then run through my target named range before calling the concerned macro email automation.
Hope my explanation is clear a little, my coding might also be amateurish. bear with me.
thanks in advance.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("Relevant"), Target) Is Nothing Then
If IsNumeric(Target.Value) And Target.Value < 0.95 And Target.Value >= 0.9 Then
Call Email
ElseIf IsNumeric(Target.Value) And Target.Value < 0.9 And Target.Value >= 0.85 Then
Call Email1
ElseIf IsNumeric(Target.Value) And Target.Value < 0.85 Then
Call Email2
End If
End If
End Sub
Bookmarks