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 return a date, given a year, month, day?

DateSerial (year, month, day)
‘all three parameters are mandatory
'year - range 100-9999
'month - range 1-12
'day - range 1-31
‘examples
MsgBox (DateSerial(2050, 4, 23)) ‘returns 4/23/2050
MsgBox (DateSerial(22, 9, 17)) ‘returns 9/17/2022