View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nbs nbs is offline
external usenet poster
 
Posts: 7
Default Date Comparison in Code

Having a problem with a date comparison...

c1 = 9/21/04 9:00:00 AM
d1 = 9/15/04 11:00:00 AM

If date (c1) (d1) then UserForm1.Show

This should show the form, but instead because 11 is
greater than 9 it does not. And, when you reverse the
formula is will show the form.

If date (c1) < (d1) then UserForm1.Show

Is there a setting or reclaration required?

Thanks,
Noel