hi all
i'm looking for date picker using with long date format (dd-mmmm-yyyy)
i want date picker can save as Ms Word Add-ins (permanent into ms word)
i hope someone give me a solution.
note:
date picker is easy to use & simple.
susanto
VBA : Date Picker With Long Date Format in Ms Word
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
-
- 4StarLounger
- Posts: 563
- Joined: 27 Jun 2021, 10:46
Re: VBA : Date Picker With Long Date Format in Ms Word
D0oesn't the Date Picker Content Control already provide exactly this functionality?
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
Re: VBA : Date Picker With Long Date Format in Ms Word
hi.. I have trying Date Picker Content Control, but I can,t see for long date format where is it.
Whatever, if possible date Picker can use/show Long Date Format.
Whatever, if possible date Picker can use/show Long Date Format.
-
- Microsoft MVP
- Posts: 1320
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: VBA : Date Picker With Long Date Format in Ms Word
In the Properties dialog, enter the format you want in the "Display the date like this" box. You don't have to pick any of the suggestions in the list below it. You can enter your long date format as dd-MMMM-yyyy (note that you need to use MMMM and not mmmm).
In VBA, you can do it this way:
In VBA, you can do it this way:
Code: Select all
Dim cc As ContentControl
Set cc = ActiveDocument.ContentControls.Add(Type:=wdContentControlDate, Range:=Selection.Range)
cc.DateDisplayFormat = "dd-MMMM-yyyy"
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
Re: VBA : Date Picker With Long Date Format in Ms Word
hi Jay Freedman..
working well!!! thank you so much.
working well!!! thank you so much.
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: VBA : Date Picker With Long Date Format in Ms Word
And, for something more elaborate (i.e. using Ordinal dates), see: https://www.msofficeforums.com/20611-post2.html
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
Re: VBA : Date Picker With Long Date Format in Ms Word
hi..i have tested that macro, but i don't see anything..macropod wrote: ↑09 Mar 2022, 04:00And, for something more elaborate (i.e. using Ordinal dates), see: https://www.msofficeforums.com/20611-post2.html
how to use/make add-ins that macro?
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: VBA : Date Picker With Long Date Format in Ms Word
Did you name the add the macro to the document's 'This Document' code module, as indicated in the post?
Did you name the Content Control 'Mydate', as indicated in the post?
Did you exit the Content Control after selecting the date?
Did you name the Content Control 'Mydate', as indicated in the post?
Did you exit the Content Control after selecting the date?
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- 3StarLounger
- Posts: 240
- Joined: 17 Feb 2022, 05:16
Re: VBA : Date Picker With Long Date Format in Ms Word
hi macropod...
i have do what you suggestion..but
still i don't see anything change
plese, give me more easy steps..
i have do what you suggestion..but
still i don't see anything change
plese, give me more easy steps..
-
- 5StarLounger
- Posts: 628
- Joined: 10 Jan 2016, 15:56
- Location: Madison, Wisconsin
Re: VBA : Date Picker With Long Date Format in Ms Word
How to use macros from forums or websites:
Global Templates and the Startup Folder
Attorney Charles Kenyon
Templates in Microsoft Word
Modifying the QAT
The Importance of Styles in Microsoft Word
Templates in Microsoft Word
Modifying the QAT
The Importance of Styles in Microsoft Word
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: VBA : Date Picker With Long Date Format in Ms Word
There are no more steps.Susanto3311 wrote: ↑09 Mar 2022, 17:25hi macropod...
i have do what you suggestion..but
still i don't see anything change
plese, give me more easy steps..
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]