VBA : Date Picker With Long Date Format in Ms Word

[Susanto3311]

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

[SpeakEasy]

D0oesn't the Date Picker Content Control already provide exactly this functionality?

[Susanto3311]

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.

[Jay Freedman]

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

1.png

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"

[Susanto3311]

hi Jay Freedman..
working well!!! thank you so much.

[macropod]

And, for something more elaborate (i.e. using Ordinal dates), see: https://www.msofficeforums.com/20611-post2.html

[Susanto3311]

And, for something more elaborate (i.e. using Ordinal dates), see: https://www.msofficeforums.com/20611-post2.html

hi..i have tested that macro, but i don't see anything..
how to use/make add-ins that macro?

[macropod]

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?

[Susanto3311]

hi macropod...
i have do what you suggestion..but
still i don't see anything change
plese, give me more easy steps..

[Charles Kenyon]

How to use macros from forums or websites:

• http://www.gmayor.com/installing_macro.htm

• http://gregmaxey.com/word_tip_pages/ins ... acros.html

Global Templates and the Startup Folder

• http://www.addbalance.com/usersguide/te ... htm#Global

• http://addbalance.com/word/startup.htm

[macropod]

hi macropod...
i have do what you suggestion..but
still i don't see anything change
plese, give me more easy steps..

There are no more steps.