Creating an Excel picklist to import into word?

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?

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 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

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.

scarlet wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html