Creating an Excel picklist to import into word?

[scarlet]

First of all is this possible?

Here is my question.

I need to create one spreadsheet in Excel whereby I can select the type
of equipment I want and it shows the model number

Type Model

Heater KT100
Heater KT200
Pump 2000
Pump 3000

This needs to be in the format of a pick list so I can select say Pump
2000 to display only. Once that is created I then wish to import it
into Word as word only allows me to input 25 choices via Drop Down Form
Fields. I can only think of creating the spredsheet in Excel and
importing it in?

 

[Debra Dalgleish]

You could embed the Excel file into the Word document but it might be
easier for your users if you use a combobox in Word, as described here:

WD2000: How to Create a Combo Box Containing More Than 25 Items
http://support.microsoft.com/default.aspx?scid=198561

 

[scarlet]

I have just tried that, clearly I am doing something wrong as it still
only allows me to select 25 entries?

 

[scarlet]

If it helps this is the code I have put in

Private Sub Cmdclose_Click()

End Sub

Private Sub ComboBox1_Change()

ActiveDocument.FormFields("Text1").Result = ComboBox1.Value

End Sub

Private Sub CommandButton1_Click()

Unload Me

End Sub

Private Sub UserForm_Click()

ComboBox1.ColumnCount = 1

'Load data into ComboBox

ComboBox1.List() = Array("Zero", "One", "Two", "Three")

End Sub

But when I insert my Drop Down Form Field I can still only pick 25,
when I get to 26 I get an error

 

[Debra Dalgleish]

You use this combobox to place the results into a textbox, so you don't
use a dropdown list in the form.

Follow the instructions in the section subtitled 'Create the Text Form
Field'

If you need more help with it, you could post a question in one of the
Word newsgroups, and someone may be able to help.