Hello.

Is it possible to clear the value and the item list of all comboboxes when the Workbook is opened? I have tried without success using an object such as this:

Dim obj as OLEObject
For Each obj in Sheet1.OLEObjects
obj.clear
Next
An error message pops up saying that the object does not support the method or property.

Thanks!