MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calendar Control

Posted by Jack on September 02, 1999 4:32 PM

Does anyone know how I can make a calendar control in a dialog box without having a large display of the month. I am working on a project that would allow the end user to select the date from the drop down dialog box.

If anyone has any answers, please post or e-mail me.


Posted by Chris on September 03, 1999 7:14 AM

I presume the way you are currently doing it is to use Calendar Control 8.0. For those of you out there who don't know about this, it creates a sizable calendar directly on your UserForm. To add it, right click on the Control Toolbox, choose Additional Controls, and select Calendar Control 8.0.

It sounds like your problem is that you don't want the calendar taking up that much space on the Form. Correct? If that is the case, one option you have would be to create the calendar on a separate small form. Then you could have a button saying "Select Date" that would launch the Calendar form. You could then return the value of the calendar control to a text box on the original Form. To me, that is a much more professional look than having dropdowns to select date values.

Hope that helps.