Results 1 to 13 of 13

VBA code for checking a specific date occur.

Threaded View

  1. 10-21-2015, 07:03 AM #1
    ExcelBG
    ExcelBG is offline
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    VBA code for checking a specific date occur.

    Hi all,

    I would be very happy if somebody can help me with the following task:

    Have a single sheet. In coloumn "A" are posted some dates.In range "B1" I have a formula that gives today`s date, in other words B1 = today. Is it possible when I activate the sheet to check a week back from the value in range "B1" and if there is a value in coloumn A range that contains in this condition to recieve a msgbox with specific text.

    Thnak u in advance.
    Last edited by ExcelBG; 10-22-2015 at 08:43 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting the number of Events that occur in a specific month in a range of days.
    By krowe111 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2015, 05:38 AM
  2. program a formula to count number of times event occur before a specific time.
    By yinxzon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2014, 04:15 AM
  3. How to add values based on date they occur?
    By browndog in forum Excel General
    Replies: 1
    Last Post: 03-16-2014, 06:02 PM
  4. Error Occur when write .Range Code
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2012, 09:57 PM
  5. Checking Date in Macro Code
    By mmwtx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2009, 11:18 PM
  6. Please help - Looking for a way to sum up for specific error codes that occur in multiple months.
    By Joe in forum Excel General
    Replies: 4
    Last Post: 06-16-2006, 11:20 PM
  7. Color Code Date Checking
    By drvortex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2006, 03:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1