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