+ Reply to Thread
Results 1 to 3 of 3

message me or warn when it reaches a certain quantity

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    message me or warn when it reaches a certain quantity

    Hi, I just wonder if this is possible or anyway to do it. I have a stock count cell formula in a workbook and it adds a column, I wonder if there was a way to give me a warning automatically when the sum of the columns equals or greater than 500 without opening the worksheet.
    So basically to tell me to order supplies when it reaches 500 without me having to open the sheet each day to check on it.

  2. #2
    Registered User
    Join Date
    09-30-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: message me or warn when it reaches a certain quantity

    Does this link help at all?

    http://www.rondebruin.nl/win/s1/outlook/bmail9.htm

  3. #3
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    Re: message me or warn when it reaches a certain quantity

    I was reading that, but instead of email I want to post a message on the computer screen or someway to alert/warn me with a message box

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] conditional format formula to color red once demand reaches/exceeds onhand quantity
    By marcella needs help in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2016, 06:18 PM
  2. [SOLVED] Running total of Quantity on Hand Vs Sales Vs Quantity to Produce
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 07:34 AM
  3. Replies: 4
    Last Post: 01-14-2015, 07:46 AM
  4. [SOLVED] Message Box to warn if data is missing
    By T15K in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2013, 07:18 PM
  5. Create message box alert when a cell value within a range reaches a certain criteria
    By Richard Myers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2013, 07:09 AM
  6. pop up message when a range of cells reaches todays date
    By ngrant01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2012, 10:31 AM
  7. Replies: 5
    Last Post: 11-23-2009, 06:24 PM

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