ActiveX

To specify the width and alignment of the combo box drop-down list box

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the TypeComboBoxWidth property.