Update Bookmarks from a Userform

alshcover · #1 04-29-2014, 05:28 PM

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)?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 and variables in document	webharvest	Word VBA	5	06-21-2011 03:22 PM