VBA IDE > View > Toolbox > Right-click on Toolbox window > Additional Controls > check Microsoft MonthView Control 6.0 (SP6) > In Toolbox, select MonthView control > drag calendar onto your userform
<label’s name>.Caption = “<text>”
lblExample.Caption = “Hello”
Put the code below in a separate module from that of the userform. A common choice for users is the proceduce of Workbook_Open() under module ThisWorkbook.
Private Sub Workbook_Open()
<user form name>.Show
Do not use the load method, as this just loads the form but does not make it visible. Besides, Show option automatically loads it anyway.
Load <user form name>