Excel Calander Tool

[Jay3]

I'm using the calander tool in microsoft excel and Ive never used it before.

I want to add data/ narrative from from cells in the spreadsheet to specific days. Can someone give an example line of code to tell me how to do this?

Thanks,
Jay3

 

[Jay3]

Does anyone have any ideas on this one?

Thanks,
Jay3

 

[Rasm]

In your code view - press F2 - then type 'Calendar' - then chose i.e. the userform type - now you get list of the properties/events.

Insert a Calendar control on userform - then right_click on the toolbox (it only shows when Userform itself has focus or goto view then select ToolBox) - it then lists all the registered OCXs that you have registred.

Not sure if this is to basic or if it helps you

Private Sub Calendar1_Click()
    textbox1 = Calendar1.Day
    textbox2 = Calendar1.Month
End Sub