Hi,
Actually, I have already created a ComboBox of ActiveX control using the following code:
Sub CrtComboBoxes_ActiveX()
ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=69, Top:=32.25, Width:=72, Height:=16).Select
End Sub
My problem is that I have to manually key in some properties like 'LinkedCell', 'ListFillRange' and more.
I am wondering if I can set up the properties in the code above. I tried but I got errors like 'Run-time error: 438': Named argument not found. I looks like it won't allow me to insert any other parameters beside those in the parentheses.
I did ComboBox of Form using the object of ControlFormat and it worked but that's not what I want. I want ActiveX.
Thanks in advance.
Actually, I have already created a ComboBox of ActiveX control using the following code:
Sub CrtComboBoxes_ActiveX()
ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=69, Top:=32.25, Width:=72, Height:=16).Select
End Sub
My problem is that I have to manually key in some properties like 'LinkedCell', 'ListFillRange' and more.
I am wondering if I can set up the properties in the code above. I tried but I got errors like 'Run-time error: 438': Named argument not found. I looks like it won't allow me to insert any other parameters beside those in the parentheses.
I did ComboBox of Form using the object of ControlFormat and it worked but that's not what I want. I want ActiveX.
Thanks in advance.