Use Date()

If Cells(j,"A")=Me.TextBox1.Text And Cells(j,"B")= Date()

If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

I have w/sheet cell B1= Now(),i.e date with time.
what vba code should I use whether B1=today's date or not.
I use :- If Cells(j,"A")=Me.TextBox1.Text And Cells(j,"B")=today
its not giving me desired results.

--
Message posted via http://www.officekb.com