Results 1 to 2 of 2

Pop up reminder

Threaded View

raycerspeed Pop up reminder 11-16-2013, 04:23 AM
raycerspeed Re: Pop up reminder 11-16-2013, 05:00 AM
  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Arrow Pop up reminder

    Hello Guys!!!

    I'm new here and I need some help with my code, right now i'm trying to have a POP UP Reminder in my excel. and I made the following code:

    Private Sub Workbook_Open()
    For Each Cell In Range("A2:A100")
    For Each Reminder In Range("B2:B100")
    If Cell.Value < Date + 3 And Cell.Value <> "" Then
    MsgBox ("You Have upcoming Deadline ") + Reminder.Value
    Cell.Interior.ColorIndex = 3
    Cell.Font.ColorIndex = 2
    Cell.Font.Bold = True
    End If
    Next
    Next
    End Sub
    its already working but the problem is once the Message box show up it will remind you all the deadline and it won't stop showing. can anybody know how to stop the looping of the message, I just need to show it once the workbook is open.

    Thanks in Advance,
    Ray
    Last edited by raycerspeed; 11-17-2013 at 02:48 AM. Reason: Complying with the rules

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pop up reminder
    By ERcoder in forum Excel General
    Replies: 2
    Last Post: 07-19-2010, 12:22 PM
  2. Pop-up Reminder
    By seanyeap in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 09-03-2009, 04:09 AM
  3. [SOLVED] Reminder pop-up
    By Digital2k in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-23-2006, 06:55 PM
  4. [SOLVED] Setting a reminder up
    By Shep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Pop-Up Reminder
    By Tony in forum Excel General
    Replies: 3
    Last Post: 03-04-2005, 07:06 AM

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