Is there a way for me to display a calendar with multiple years, months and days for input from the user?
I am sure you have seen this method for input before, but I can't figure out how to plug one into my custom user form without downloading some junk off the internet that probably wouldn't be approved by IT.
1. Open the userform
2. Click View -> Toolbox
3. Right Click on 'Controls' tab and select 'Additional Controls' option
4. Select 'Calender Control x.0' in the Available controls list box and click 'OK'.
Now Calender Control will be displayed in your tool box so that you can drag and drop to your userform.