A
Arkwright
Hi Folks,
Many thanks in advance.
I have a Word 2000 document (could be a 2003 doc, if that would help
with several comboboxes on it; one on each line of a table. The lis
items in each combobox are exactly the same (and in the same order)
lets say; Apples, Oranges, Pears, Bananas, for example.
If the user selects, Bananas, then a message box opens to say that the
are, say, Fair Trade from the Carribean".
My code works for the first Combobox, but I don't know how to make i
work for every single combobox in the document, without cutting
pasting it and then updating the combobox number. My code so far is:
Private Sub combobox2_Change()
If ComboBox2.Value = "Bananas" Then
MsgBox "These are Fair Trade from the Carribean."
End If
End Sub
I have played around with InlineShapes and managed to get the messag
to pop-up for several boxes, and guess that I need to change the su
name to something else rather than refering to combobox2, but don't kno
what or how?
Your help would gratefully be appreciated.
Cheer
Many thanks in advance.
I have a Word 2000 document (could be a 2003 doc, if that would help
with several comboboxes on it; one on each line of a table. The lis
items in each combobox are exactly the same (and in the same order)
lets say; Apples, Oranges, Pears, Bananas, for example.
If the user selects, Bananas, then a message box opens to say that the
are, say, Fair Trade from the Carribean".
My code works for the first Combobox, but I don't know how to make i
work for every single combobox in the document, without cutting
pasting it and then updating the combobox number. My code so far is:
Private Sub combobox2_Change()
If ComboBox2.Value = "Bananas" Then
MsgBox "These are Fair Trade from the Carribean."
End If
End Sub
I have played around with InlineShapes and managed to get the messag
to pop-up for several boxes, and guess that I need to change the su
name to something else rather than refering to combobox2, but don't kno
what or how?
Your help would gratefully be appreciated.
Cheer