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



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 09:06 AM.


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