View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lataa3 via OfficeKB.com lataa3 via OfficeKB.com is offline
external usenet poster
 
Posts: 9
Default comparing excel dates in vb macro

I am just into vb macro. so Could anybody please help me out! I want to
know comparison of two dates of excel in macro, since there is mismatch of
formats (EXCEL :DD-MM-YY & VB:mm/dd/yy)

Could you help me coding - how to compare two dates in Macro.
Suppose A1 contains 28-11-00. I want to check whether the value in A1 is
LESS THAN 02-3-01 and greater than or equal to 16-12-98 .

Thanking you in anticipation

With regards

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200908/1