Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-29-2014, 05:28 PM
alshcover alshcover is offline Update Bookmarks from a Userform Windows 7 64bit Update Bookmarks from a Userform Office 2010 64bit
Novice
Update Bookmarks from a Userform
 
Join Date: Apr 2014
Posts: 9
alshcover is on a distinguished road
Question Update Bookmarks from a Userform

What I have done so far:
  • I created a UserForm.
  • I added a Control (DTPicker) and named it "dtDateFiled".
  • I added a Control (CommandButton) and named it "cmdOK".
  • I inserted a bookmark in the Word Template titled "DateFiled"; therefore, the date that the User selects on the UserForm (dtDateFiled) shows up in the Word document.

Here is the code:

Quote:
Private Sub cmdOK_Click()
Application.ScreenUpdating = False
With ActiveDocument
.Bookmarks("DateFiled").Range.Text = dtDateFiled.Value
End With
Application.ScreenUpdating = True
Unload Me
End Sub
What currently happens:
The date selected by the User is inserted at the bookmark just fine, but the date displays in this format: MM/DD/YYYY (e.g., 4/29/2014).

Question:
How do I change the date format to display: Month DD, YYYY (e.g., April 29, 2014)?
Reply With Quote
 

Tags
date, format, userform



Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Bookmarks from a Userform Checkbox in Userform lukael Excel Programming 5 02-18-2014 05:20 AM
Userform Code not quite right - help please vbanovice Word VBA 1 09-29-2013 09:20 PM
Update Bookmarks from a Userform Help with a drop down in userform and variables leemoreau Word VBA 1 09-14-2013 06:01 AM
VBA code to update record in Access 2003 using Userform in Excel primmer3001 Excel Programming 0 08-29-2011 04:25 PM
Update Bookmarks from a Userform Update bookmarks and variables in document webharvest Word VBA 5 06-21-2011 03:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 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