Fun with Forms

[ck1999]

I am trying to create a form in word 97 and wanted to populate the dropdown boxes with a list of company names pulled from an excel spreadsheet. Is their an easy way to do this.

Ck1999

 

[fumei]

What have you tried so far?

Gerry

 

[CautionMP]

And how often do the company names change in the Excel workbook?

CMP

Instant programmer, just add coffee.

 

[SkipVought]

Hi,

What's the ultimate objective?

Is this like a form letter or a form?

A form letter (variable flowing text) is best suited to a word processor.

A form could be done in either a word processor or a spreadsheet. With Excel, you have much better control of placement and type of controls.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[ck1999]

I am trying to populate a formfield dropdown box in microsoft word with a list of vendors. This list will come from excel. However I have discovered that the dropdown box can only contain 25 items. And I have about 70 vendor names. Currently I have chosen to use the most 25 common vendors and use these. However I would like to know if their is a way for a dropdown to contain more than 25 entries. I realize I can use a vba form with a combobox but was not wanting to.
Also the list will be continually updated with new vendors.

Chris

 

[fumei]

A formfield dropdown...no, there is not. 25 is the limit.
An ActiveX dropdown....yes, you can. I am not sure what the limit is, but I just made one with over 100.

From a design point of view, however, 70 items in a dropdown is too much.

Gerry

 

[ck1999]

can an activex dropdown be included in a form style letter or can it only be on a vba form. I did not want to make a pop-up form

Chris

 

[fumei]

Sorry, I missed the reply. Yes, you can insert an ActiveX control right in the document. Use the Controls toolbar View > Toolbars > Controls.

Gerry