What is the syntax to auto-move days on a calendar?

<calendar name>.Value = <calendar name>.Value <+/-> <number of days you want to move forward or back>

‘examples
myCalendar.Value = myCalendar.Value + 1 'move forward one day
monthview.Value = monthView.Value -5 'move backward 5 days

What is the syntax to get the date selected for a calendar?

1. Add a calendar to your userform (for instructions, click here)
2. As shown in the screenshot below, select your calendar control (default name is always MonthView1)
3. Select DateClick, as shown circled in red below
4. A procedure will be auto-generated, containing a parameter called DateClicked
5. User’s selected date is automatically contained in variable DateClicked

What is the syntax to add a calendar to a userform?

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