J
Johanna Gronlund
Hello,
On my userform, I have a combobox that I have set up for my 49 items. The
code looks like this:
Private Sub ComboBox1_Change()
ActiveDocument.FormFields("Text1").Result = ComboBox1.Value
End Sub
Private Sub Cmdclose_Click()
Unload Me
End Sub
Private Sub UserForm_Initialize()
ComboBox1.ColumnCount = 1
'Load data into ComboBox
ComboBox1.List() = Array("Option1", "Option2", "Option3", ..."Option49")
End Sub
At the moment, the users can select any of the options I have provided in my
combobox or type their own option. How can I limit their choice just to those
on the combobox? I have
Many thanks in advance,
Johanna
On my userform, I have a combobox that I have set up for my 49 items. The
code looks like this:
Private Sub ComboBox1_Change()
ActiveDocument.FormFields("Text1").Result = ComboBox1.Value
End Sub
Private Sub Cmdclose_Click()
Unload Me
End Sub
Private Sub UserForm_Initialize()
ComboBox1.ColumnCount = 1
'Load data into ComboBox
ComboBox1.List() = Array("Option1", "Option2", "Option3", ..."Option49")
End Sub
At the moment, the users can select any of the options I have provided in my
combobox or type their own option. How can I limit their choice just to those
on the combobox? I have
Many thanks in advance,
Johanna