Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date fields in excel user form
Hi All, I have created an Excel User form wtih Date fields. Is there a way I can show calendar popup once the user clicks on any of the Date Text Input fields? If not, Is there a way I can format the text field such that it displays and accepts data in this format "mm/dd/yyyy"?? The form input is then exported to access 2007 DB, So i would want the same to be displayed in access as well. Thanks in Advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date fields in excel user form
http://www.rondebruin.nl/calendar.htm http://www.fontstuff.com/access/acctut09.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: Hi All, I have created an Excel User form wtih Date fields. Is there a way I can show calendar popup once the user clicks on any of the Date Text Input fields? If not, Is there a way I can format the text field such that it displays and accepts data in this format "mm/dd/yyyy"?? The form input is then exported to access 2007 DB, So i would want the same to be displayed in access as well. Thanks in Advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable / Disable User Form Fields Based on Input. | Excel Programming | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Detecting Ctrl-Tabs in User Form input fields? | Excel Programming |