Creating longer drop down tables

[Christine]

I've tried using visual basic to create a drop down box
with more than 25 items, but for some reason I can't get
it to work. I tried the steps put out by Microsoft online,
but all that pops up is an empty list.

 

[Doug Robbins - Word MVP]

Did you include the equivalent of this piece of code in the code behind the
userform

Private Sub UserForm_Initialize()
ComboBox1.ColumnCount = 1
'Load data into ComboBox
ComboBox1.List() = Array("Zero", "One", "Two", "Three")
End Sub

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP