Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

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.

THANKS!!!!!


Re: Calendar Control

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.

Chris


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.