On Tue, 21 Sep 2004 07:33:38 -0700, "Robert Christie"
wrote:

Ron

it seems my second to last post got lost.
basically I was asking what is the difference between
user entered dates and machine modified dates.
Also does Vba code re-act differently on each.

Tia
Bob C.


If the user enters, let us say, 6 Sep 2004 and then pushes the button, the date
will, of course, back up to 5 Sep. That is in accord with what you have posted
for the design.

But, if the user enters 5 Sep and pushes the button, the date will back up to 5
Aug. (Using the last code posted). I was not sure if this was behavior that
you wanted.

So the "user-entered" date is the date that the user types into the cell. The
"machine-modified" date is the result after executing the macro by pushing the
button.


--ron