Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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


Re: dynamic calendar?

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


Re: dynamic calendar?

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



Re: dynamic calendar?

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



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.