With a Word ContentControl DatePicker how do i get the value?

vba ms-word word-2010
QueueHammer picture QueueHammer · May 30, 2012 · Viewed 8.6k times · Source

I have a ContentControl that is a DatePicker in a word document. I'm trying to use it to populate some value in a code behind but I cant seem to get the value out of it.

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, _
    Cancel As Boolean)

None of the properties on ContentControl are close to .Value or .Text. I have seen other content controls use:

ContentControl.DropdownListEntries(1).Text
ContentControl.DropdownListEntries(1).Value

This, as expected for a DatePicker, does not work but it is the only property of ContentControl that returns anything close to the value I want.

How do i get the date from the DatePicker ContentControl?

Answer

Siddharth Rout picture Siddharth Rout · May 30, 2012

Is this what you are trying?

Private Sub Document_ContentControlOnExit(ByVal ContentControl _
As ContentControl, Cancel As Boolean)
    MsgBox ContentControl.Range.Text
End Sub

SNAPSHOT

enter image description here

Related questions

Create Range from current cursor position Word 2010 VBA

I have a .docm document with a user form. On the user form I have a button that needs to insert something (some text, for starter) at the last known cursor position in the document. For this, I want to …

Read More
Save the cursor position in a document and return there later on

I have a macro that scans my document for Heading 1 styles, and consequently the cursor is moved to after the last match. I'm trying to capture the location of the cursor before this scan occurs, and then return to that …

Read More
How do you correctly set document properties using VBA?

The problem I'm having some trouble setting document properties using VBA in Word 2010. I have a document containing several Heading 1 sections and I use a macro to extract a selected section (along with it's contents) and paste it to a …

Read More