ExcelBanter - Calendar Control

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calendar Control (https://www.excelbanter.com/excel-programming/365247-calendar-control.html)

Patrick Simonds

Calendar Control

How do you make a calendar control display the current date when it is
opened?

Chip Pearson

Calendar Control

Try

Sub Auto_Open()
Worksheets("SHeet1").OLEObjects("Calendar1").Objec t.Value =
Now
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Patrick Simonds" wrote in message
...
How do you make a calendar control display the current date
when it is opened?

All times are GMT +1. The time now is 02:34 AM.