Using vb comboBox is it possible to add the same items to numerous comboBox on the same sheet?
I have been trying the following....
Dim mycntrl As OLEObject
Dim sht As Worksheet
Set sht = ActiveSheet
For Each mycntrl In sht.OLEObjects
mycntrl.addItem "item1"
Next mycntrl
However I noticed that the addItem method is not available when trying this, so how would you add an item in a loop?
thank you in advance for any help
Bookmarks