#1
|
|||
|
|||
Date Picker
Can anyone tell me if there is way of including a date picker within a userform... I have two fields that require completion <Ref No> and <Date> which I then want to merge to form a single response, i.e. Prompt...Enter Ref No. Prompt....Enter Date....select from picker. Submit response, which would be displayed as follows... XXXX/22JUL11 where, XXXX = Ref No. Date formatted as displayed |
#2
|
||||
|
||||
Hi Andy,
Right-click on the userform toolbox, choose 'Additional controls', then select the 'Mirosoft Date and Time Picker Control'. You can then add the control to your userform.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your response, however I do not have the MS date picker in my tools list... Is there any way of downloading it?
|
#4
|
||||
|
||||
Hi Andy,
AFAIK, it was added to the userform tools available in Office at least as far back as Office 2003, so you should have it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
AFAIK, it is not included in Office 2010. You can search for the file, MSCOMCT2.OCX, and see if you have it on your system. If you do, you can register it by following the instructions at:
http://social.technet.microsoft.com/...d-cd0e6411da94 If it is not on your system, go to: support.microsoft.com/kb/297381 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to custom Date Picker CC format with Ordinal and superscript it! | areriff | Word VBA | 5 | 08-21-2022 04:28 PM |
Color picker eye dropper ??? | stoneygeorge | PowerPoint | 7 | 08-28-2012 12:32 AM |
word 2003 date picker | nashville | Word | 16 | 04-06-2012 04:12 AM |
Calculations using values from date picker controls | Inkarnate | Word | 0 | 06-09-2010 07:16 AM |
Word 2007 date and time picker | dmcohio | Word | 2 | 04-09-2010 04:13 AM |