Creating an Excel picklist to import into word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scarlet - 03 Sep 2005 14:03 GMT

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?

Reply to this Message

Debra Dalgleish - 03 Sep 2005 14:19 GMT

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

> First of all is this possible?
>
[quoted text clipped - 15 lines]
> Fields. I can only think of creating the spredsheet in Excel and
> importing it in?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

scarlet - 03 Sep 2005 15:07 GMT

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

Reply to this Message

scarlet - 03 Sep 2005 15:32 GMT

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

Reply to this Message

Debra Dalgleish - 03 Sep 2005 16:42 GMT

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.

> If it helps this is the code I have put in
>
[quoted text clipped - 26 lines]
> But when I insert my Drop Down Form Field I can still only pick 25,
> when I get to 26 I get an error

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message