MrExcel Publishing
Your One Stop for Excel Tips & Solutions

dynamic calendar?


Posted by Chris on July 14, 2001 9:11 AM

does anyone know how to make a calendar (similar to the one in "Date/Time Properties") appear in an excel worksheet... and then dynamically update w/the system clock?

Thanks,
Chris

Posted by Ivan F Moala on July 14, 2001 3:44 PM

You could use the mscalendar control avail
via the toolbox control / more controls.
If you don't find it then you can get it here
You need the mscal.ocx
avail from http://www.miesoftware.com/sonline/ols44.htm

Ivan

Posted by Chris on July 14, 2001 6:50 PM

Thanks Ivan -

the other half of the question now:

anyone know how to make the calendar date = now?

-Chris


Posted by Ivan F Moala on July 14, 2001 7:26 PM

There should be a reference for the properties
= linkedcell.......link this to a range with the
formula =Now()


Ivan