Bob,

Do understand that the Now function in this example is not the same as the
worksheet function NOW(). They basically do the same things, but when you
enter the latter in a worksheet, Excel will generally automatically format
it as time, but in VBA Now just returns a time serial value which you need
to format if outputting to a worksheet cell (as the code does).

This becomes more clear with today's date, the worksheet function is
TODAY(), the VBA equivalent function is Date.

As well as invoking the code in -line, you could call a macro once the
criteria are established.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
thank you, works great!
Now I get it, how to trigger an event and apply a function.

thanks,
bobd