Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-27-2010, 10:19 AM
Kimberly Kimberly is offline word 2003 date picker Windows 7 word 2003 date picker Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

There is no date picker in 2003. You can add a calendar control and some VBA to insert the selected date in the document.
The calendar control can be found at Insert > Object > Calendar control

To do the VBA, start by typing 11 characters in the doc where you want the date to be displayed (these 11 characters will be replaced by the date).
Turn on the macro recorder and press Ctrl+Home to go to the top of the doc, then use the keyboard to navigate to and select the 11 characters.
Turn off the recorder.
View the macro code and copy the lines that start with "Selection"
Exit the code window
Double click on the calendar control
Between the Private Sub and End Sub lines, paste the lines from the previous macro
Just before the End Sub line, add this line:
Code:
    Selection.Text = Format(Calendar1.Value, "mmm dd yyyy")
The code will resemble:
Code:
Private Sub Calendar1_Click()
    Selection.HomeKey Unit:=wdStory
    Selection.MoveDown Unit:=wdLine, Count:=10
    Selection.MoveRight Unit:=wdCharacter, Count:=11, Extend:=wdExtend
    Selection.Text = Format(Calendar1.Value, "mmm dd yyyy")
End Sub
Return to Excel
Exit design mode of the Calendar Control
Test
If it works, delete the original macro that you recorded.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations using values from date picker controls Inkarnate Word 0 06-09-2010 07:16 AM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM
Word 2007 date and time picker dmcohio Word 2 04-09-2010 04:13 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
word 2003 date picker Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft