galileogali
Well-known Member
- Joined
- Oct 14, 2005
- Messages
- 748
I have two controls, Oleobjects on the Worksheet. I want to go OleOjects with VBA and recognize what type Combobox. How is this property get?
Sub limpiarCmbs()
Dim ctrl As OLEObject
For Each ctrl In ActiveSheet.OLEObjects
If ctrl.??????= "Forms.ComboBox.1" Then
ctrl.Text = vbNullString
End If
Next
End Sub
Sub limpiarCmbs()
Dim ctrl As OLEObject
For Each ctrl In ActiveSheet.OLEObjects
If ctrl.??????= "Forms.ComboBox.1" Then
ctrl.Text = vbNullString
End If
Next
End Sub