Results 1 to 17 of 17

Not running macro on automatic calculation

Threaded View

  1. #5
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Not running macro on automatic calculation

    I now have this which works fine

    Private Sub CheckBox1_Click()
    Dim OutlookApp As Object
    Dim Mess As Object, Recip
    Recip = [L7].Value
    Set OutlookApp = CreateObject("Outlook.Application")
    Set Mess = OutlookApp.CreateItem(olMailItem)
    With Mess
    .Subject = "Task Completed"
    .Body = "XXXXXX XXXXXX has completed task" & " " & Range("C7").Value
    .To = Recip
    .Display
    .Send
    End With
    End Sub
    But works on check and uncheck, there is no Check_Event or Uncheck_Event so how do i stop it from sending the email when its unchecked, i only want it to do it when it is checked?
    Last edited by shiftyspina; 03-13-2014 at 10:45 AM. Reason: Name showing (privacy)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. automatic running macro daily using ontime method
    By yellowpower in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2012, 12:04 PM
  2. Automatic calculation and macro's
    By digger713 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 05:57 PM
  3. Automatic Running Macro
    By titanxt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2008, 01:57 AM
  4. Automatic running of Macro for the whole spreadsheet
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2005, 05:05 PM
  5. running macro at automatic time intervals
    By tjb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2005, 06:06 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