 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / December 2007Dialog Box
I am trying to create a dialog box that allows the user to selct a date from a calender. If this is not possible, is there a way to format the box to only accept a specific date format?  SignatureThanks, Fanew3 http://orlando.mvps.org/#Calculator >I am trying to create a dialog box that allows the user to selct a date >from > a calender. If this is not possible, is there a way to format the box to > only > accept a specific date format? There are 2 easy to access built in calendars. To get at them bring up the Control Toolbox (Tools | Customize | Toolbars | Control Toolbox). On that toolbar there is an icon that looks like a hammer and wrench. Selecting this gives you a drop down. Select either the Microsoft Date & Time picker (my favorite) or the Microsoft MonthView control. When first added the sheet will be in design mode. Right click on the control and select properties. Put a cell address in the Linked Cell Property. Close the properties window. To exit design mode click the icon that looks like a ruler and triangle. SignatureHTH... Jim Thomlinson > I am trying to create a dialog box that allows the user to selct a date from > a calender. If this is not possible, is there a way to format the box to only > accept a specific date format? Jim, The two solutions you sited sound great. However, I am not finding either in the drop-down list from the control toolbar. Are these options standard built ins or do I need to download from Microsoft? I am using XP Professional. Thanks for your help. SignatureThanks, Fanew3 > There are 2 easy to access built in calendars. To get at them bring up the > Control Toolbox (Tools | Customize | Toolbars | Control Toolbox). On that [quoted text clipped - 8 lines] > > a calender. If this is not possible, is there a way to format the box to only > > accept a specific date format? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.