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
Bookmarks