Results 1 to 9 of 9

Assigning Event handler to a button

Threaded View

Tes0506 Assigning Event handler to a... 05-19-2015, 11:57 AM
Norie Re: Assigning Event handler... 05-19-2015, 12:15 PM
Tes0506 Re: Assigning Event handler... 05-19-2015, 02:36 PM
Norie Re: Assigning Event handler... 05-19-2015, 02:56 PM
Tes0506 Re: Assigning Event handler... 05-19-2015, 03:16 PM
Norie Re: Assigning Event handler... 05-19-2015, 03:22 PM
Tes0506 Re: Assigning Event handler... 05-19-2015, 03:37 PM
Tes0506 Re: Assigning Event handler... 05-19-2015, 04:30 PM
Tes0506 Re: Assigning Event handler... 05-19-2015, 03:58 PM
  1. #1
    Registered User
    Join Date
    05-17-2015
    Location
    Manchester
    MS-Off Ver
    2010, 2007
    Posts
    6

    Question Assigning Event handler to a button

    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
    Last edited by Tes0506; 05-19-2015 at 01:37 PM. Reason: code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Event Handler
    By sighlent1 in forum Excel General
    Replies: 5
    Last Post: 02-15-2011, 11:47 AM
  2. Changing Event handler
    By Kop99 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-16-2009, 07:35 AM
  3. Event handler or a macro
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-09-2008, 02:43 PM
  4. Event handler
    By VBA Noob in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2006, 10:55 AM
  5. [SOLVED] Event handler is invalid
    By Minh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2005, 10:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1