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
Advertisements

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

unnamed.png