Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2016, 04:00 AM
shadowplay shadowplay is offline export data from content control properties Windows 10 export data from content control properties Office 2013
Novice
export data from content control properties
 
Join Date: Jul 2016
Posts: 1
shadowplay is on a distinguished road
Smile export data from content control properties

Hi,

In the form I have are several dropdown boxes.
I would like to extract the list that is contained in this dropdown list as we are transferring the data from a word document form to a SharePoint infopath form
Is this possible and if so how?

Greatly appreciated.
Thanks


Reply With Quote
  #2  
Old 07-04-2016, 11:36 PM
DougMVP DougMVP is offline export data from content control properties Windows 7 32bit export data from content control properties Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

Use an adaptation of the following

Dim i As Long
With Selection.Range.ContentControls(1)
For i = 2 To .DropdownListEntries.count
MsgBox .DropdownListEntries(i)
Next i
End With

DropdownListEntries(1) will return the place holder text, hence use For i = 2 to
Reply With Quote
Reply

Tags
export content data

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add custom doc properties in "Doc properties control" eazysnatch Word 2 09-13-2017 08:08 PM
export data from content control properties Content Control Copy - Copies Data and CC itself shammi_raj Word 3 03-30-2016 07:01 PM
export data from content control properties Clicking the selected Content Control checkbox returns wrong control in vba event DougsGraphics Word VBA 2 06-24-2015 07:31 AM
Properties for data entry control on Form help EricMannzi Word VBA 10 02-24-2015 09:48 AM
export data from content control properties Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM

Other Forums: Access Forums

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