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?
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
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?
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
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.