troubleshooting Question

Active Cell = Today ?

Avatar of RWayneH
RWayneHFlag for United States of America asked on
VBAMicrosoft ExcelMicrosoft Office
13 Comments4 Solutions716 ViewsLast Modified:
I am trying to check the value of a cell, to see if it is equal to today date or not?

Format of the ActiveCell is:

  : StartTimeStamp : #5/1/2017 7:57:12 AM# : Variant/Date

Here is what I have so far.  How do I get this to a True or Yes?  Keeps returning False/No.   Any ideas?

Sub Macro2()
    Range("B1000").Select  'No days task items should ever reach 1000 lines

    StartTimeStamp = ActiveCell.Value
    Do While Not StartTimeStamp = Now()
        StartTimeStamp = ActiveCell.Value
        MsgBox ("No")
        ActiveCell.Offset(-1, 0).Select

End Sub

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros