+ Reply to Thread
Results 1 to 2 of 2

Automated Popup When Cell exceeds certain Value

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    Cambridge
    Posts
    1

    Automated Popup When Cell exceeds certain Value

    Hi,

    Can anyone help to provide a method to do the following:

    On opening a workbook, if a particular value in a defined cell in a particular worksheet exceeds a certain value, Excel automatically generates a popup window informing the user of such.

    To put it into context, I store a lot of data in workbooks for clients, split into different worksheets in each workbook (1 workbook per client). Inside is an account summary page and if their account is overdue/underpaid (i.e. value is above 0) l would like for Excel to notify me with a popup every time I open that client's workbook until the account is clear.

    I've had a look around, but I've not been able to compile anything that works.

    Many thanks in advance for anyone who can help!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Try a workbook module, it will kick in the code whenever you activate a sheet, could become a pain in the butt eventually though
    Please Login or Register  to view this content.
    This is where the workbook module is
    http://www.contextures.com/xlvba01.html#Workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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