Very dumb question about initializing combo box that uses array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chowgirl - 31 Jan 2006 23:35 GMT

Here's the code I'm using to populate some very simple comboboxes with
hard-coded items:

Private Sub ComboBox1_Change()
ComboBox1.List = Array("Functional", "Look and feel", "Usability",
"Performance", "Operational", "Maintenance", "Security", "Legal",
"Other")
End Sub

Private Sub ComboBox2_Change()
ComboBox2.List = Array("1", "2", "3", "4", "5")
End Sub

Private Sub ComboBox3_Change()
ComboBox3.List = Array("1", "2", "3", "4", "5")
End Sub

The trouble is, when I close and re-open the .dot or .doc, the
comboboxes are empty. Do I have to use something other than array, such
as AddItem (or whatever it is)?

Thanks.

Reply to this Message

Greg Maxey - 31 Jan 2006 23:43 GMT

Put it in a UserForm Initialize routine

Private Sub UserForm_Initialize()
Me.ComboBox1.List = Array("Functional", "Look and feel", "Usability", _
"Performance", "Operational", "Maintenance", "Security", "Legal", _
"Other")
End Sub

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Here's the code I'm using to populate some very simple comboboxes with
> hard-coded items:
[quoted text clipped - 18 lines]
>
> Thanks.

Reply to this Message

Rate this thread: