Hi,
I create a combo box using the following:
However, when it is created, the height is set as 20.25 and the Top as 78.75.
Has anyone got any idea why the properties of this combo box are different to the properties set in my VBA?
Cheers,
E
I create a combo box using the following:
Code:
If CheckExists("cmbBaseD") = False Then With ActiveSheet
.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=159.75, Top:=80.25, Width:=75.75, Height:=19.5) _
.Name = "cmbBaseD"
.OLEObjects("cmbBaseD").ListFillRange = "DynRng"
End With
However, when it is created, the height is set as 20.25 and the Top as 78.75.
Has anyone got any idea why the properties of this combo box are different to the properties set in my VBA?
Cheers,
E