| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
import an excel list into a word drop-down form
I would like to convert a column in excel into a drop-down list in a word
form. The column is over 400 rows long. How do I do this? |
|
#2
|
|||
|
|||
|
import an excel list into a word drop-down form
Dropdown lists can contain only 25 entries, which in your case is probably a
good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
|
#3
|
|||
|
|||
|
import an excel list into a word drop-down form
Thanks,
How do I import a 25-item list? All I know how to do is enter each entry individually. "Suzanne S. Barnhill" wrote: Dropdown lists can contain only 25 entries, which in your case is probably a good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
|
#4
|
|||
|
|||
|
import an excel list into a word drop-down form
I don't know of any other way, either, but if you post in one of the
programming NGs, someone may be able to tell you how to populate a list using VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... Thanks, How do I import a 25-item list? All I know how to do is enter each entry individually. "Suzanne S. Barnhill" wrote: Dropdown lists can contain only 25 entries, which in your case is probably a good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
|
#5
|
|||
|
|||
|
import an excel list into a word drop-down form
Here is some basic code which will do it:
Set xlApp = CreateObject("Excel.Application") xlApp.Workbooks.Open "C:/Path To/Workbook.xls" With Selection.FormFields("Dropdown1").DropDown.ListEnt ries .Clear For i = 1 To 25 ' Rows wanted .Add Name:=xlApp.activesheet.Cells(i, "A") ' in column "A" Next End With xlApp.Quit Set xlApp = Nothing -- Enjoy, Tony "Suzanne S. Barnhill" wrote in message ... I don't know of any other way, either, but if you post in one of the programming NGs, someone may be able to tell you how to populate a list using VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... Thanks, How do I import a 25-item list? All I know how to do is enter each entry individually. "Suzanne S. Barnhill" wrote: Dropdown lists can contain only 25 entries, which in your case is probably a good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
|
#6
|
|||
|
|||
|
import an excel list into a word drop-down form
Thank you.
What is the procedure for entering a code? "Tony Jollans" wrote: Here is some basic code which will do it: Set xlApp = CreateObject("Excel.Application") xlApp.Workbooks.Open "C:/Path To/Workbook.xls" With Selection.FormFields("Dropdown1").DropDown.ListEnt ries .Clear For i = 1 To 25 ' Rows wanted .Add Name:=xlApp.activesheet.Cells(i, "A") ' in column "A" Next End With xlApp.Quit Set xlApp = Nothing -- Enjoy, Tony "Suzanne S. Barnhill" wrote in message ... I don't know of any other way, either, but if you post in one of the programming NGs, someone may be able to tell you how to populate a list using VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... Thanks, How do I import a 25-item list? All I know how to do is enter each entry individually. "Suzanne S. Barnhill" wrote: Dropdown lists can contain only 25 entries, which in your case is probably a good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
|
#7
|
|||
|
|||
|
import an excel list into a word drop-down form
Wrap the code I posted with this line in front:
Sub FillDropDown() and this line behind: End Sub and see: http://www.gmayor.com/installing_macro.htm -- Enjoy, Tony "Steve" wrote in message ... Thank you. What is the procedure for entering a code? "Tony Jollans" wrote: Here is some basic code which will do it: Set xlApp = CreateObject("Excel.Application") xlApp.Workbooks.Open "C:/Path To/Workbook.xls" With Selection.FormFields("Dropdown1").DropDown.ListEnt ries .Clear For i = 1 To 25 ' Rows wanted .Add Name:=xlApp.activesheet.Cells(i, "A") ' in column "A" Next End With xlApp.Quit Set xlApp = Nothing -- Enjoy, Tony "Suzanne S. Barnhill" wrote in message ... I don't know of any other way, either, but if you post in one of the programming NGs, someone may be able to tell you how to populate a list using VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... Thanks, How do I import a 25-item list? All I know how to do is enter each entry individually. "Suzanne S. Barnhill" wrote: Dropdown lists can contain only 25 entries, which in your case is probably a good thing. Do you really expect users to scroll through a dropdown list of 400 items? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Steve" wrote in message ... I would like to convert a column in excel into a drop-down list in a word form. The column is over 400 rows long. How do I do this? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up template in vbeditor without proggramming language | New Users | |||
| Envelope Address | New Users | |||
| Macros - Keyboard Commands | Microsoft Word Help | |||
| WordPerfect keyboard macro>Word equivalent? | New Users | |||
| Continuous breaks convert to next page breaks | Microsoft Word Help | |||
Linear Mode
