Userform

Hello Lisa,

Thank you for your question regarding calendar drop downs.

There are numerous ways to achieve what your require. I'll explain a simple method using Microsoft's own built in Calendar control.

If you are viewing your Userform in VB Editor, move your mouse over the Toolbox (the one with all the buttons on such as text box, checkboxes etc..) and right click. From the pop up menu select additional Controls. From the dialog box scroll through to find a conotrol called Microsoft Date and Time Picker, Select this and OK. You should see a new button on the toolbox. (If not, repeat again!).
Select this new tool and draw it on the Userform. When viewed you should see the calendar drop menu.
Obviously you'll need to code it to place the date somewhere!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer