XL98: Run-Time Error 57121 If Macro Uses ControlFormat Object

MORE INFORMATION

The following line of code will not work in either Microsoft Excel 98 Macintosh Edition or Microsoft Excel 97 for Windows:

   ActiveSheet.Shapes("ListBox1").ControlFormat.ListFillRange = _
 
       "$A$1:$A$10"
				

In Microsoft Excel 98 Macintosh Edition, the code fails because ActiveX controls are not supported. In Microsoft Excel 97 for Windows, the code fails because the ControlFormat object does not apply to ActiveX controls. For more information about this issue in Microsoft Excel 97, please see the following article in the Microsoft Knowledge Base: If ListBox1 is a Microsoft Excel list box, as opposed to an ActiveX list box, and if the workbook does not contain any ActiveX controls, the code works correctly.