Problem with OLEObjects

[augustus]

Hi,

My code:
For Each objOLE In Sheet1.OLEObjects
If objOLE.progID = "Forms.ComboBox.1" Then
With .OLEObjects(objOLE.Name).Object
.Enabled = False
.Clear
.value = ""
End With
End If
Next

For some reason, when I checked the Properties Enable, they remain as True.
But, they are grey out. And this cause problem to a commandbutton which would
initilise this combobox, since they remain grey out.

Thanks

[Leith Ross]

Hello Augustus,

The reason the Properties show Enabled as true and when the code runs Enabled is false has to do with binding. The properties are the default settings. These are read during interpretation and assigned upon their first reference in code. OLEObjects bind late or during execution of the code.

Initialization of the ComboBox is also early binding. Once the code is running there is no reason you can't re-enable the ComboBoxes during the Form Activate Event or have another control does this when it is selected.

Hope this answers a few questions and gives you some ideas,
Leith Ross