Posted to microsoft.public.excel.programming

tkraju via OfficeKB.com tkraju via OfficeKB.com is offline

external usenet poster

Posts: 109

vba for Today()

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
today	stew	Excel Discussion (Misc queries)	4	September 19th 08 06:15 PM
Keep 6 months of dates from Today to (Today + 6 Months)	Joe K.	Excel Programming	1	October 9th 07 07:02 PM
Before today	MAustin	Excel Discussion (Misc queries)	2	October 2nd 07 04:54 PM
IF TODAY equals date in cell A10, or if TODAY is beyond that date	SoupNazi	Excel Worksheet Functions	4	April 23rd 07 01:14 AM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.	Fkor	Excel Discussion (Misc queries)	3	March 10th 05 08:29 AM

All times are GMT +1. The time now is 06:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us