Tuesday, March 8, 2016

Calendar With Event Planner (To-Do List)

            Data can be recorded with userform to selected date . Data on userform are transferred in the Excel sheet as automatically.       



In this agenda example ,we used "Calendar Class"  instead of calendar control .
Calendar Control is an ActiveX Control and it gives error on some excel versions.  
The Calendar Class works in all version of Office VBA (Excel, Word, PowerPoint, Outlook)

The Calendar Class itself can not be added directly to the form, we need to put it to the source, as a new member of userform.