Results 1 to 3 of 3

Macro does not run based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2007
    Posts
    57

    Macro does not run based on cell value

    I am on the committee of my local youth football league and I am trying to put together a simple to use Excel 2003 spreadsheet for committee members to issue fines to clubs.

    I have created the attached file which allows them to enter the required data in the yellow cells and then generate an e-mail by clicking on the 'Send E-mail' button.

    What I would like to do is not run the 'Send E-mail' macro if the data is incomplete but instead displays the message 'Data is incomplete. Please check and try again'. If the data is imcomplete the value in cell D13>0.

    Can anyone help?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-16-2014, 09:55 AM
  2. Macro to change colour of cell based on finding a specific word in the cell
    By Shelby761 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 09:46 AM
  3. Create Auto-Calculating Cell and Assign Cell Values Based on a Macro
    By Titanium Fox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 12:00 AM
  4. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 AM
  5. Macro to auto populate the destination cell based on the values of the previous cell
    By Avinash Kumar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2009, 02:06 AM

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