![]() ![]() For example, the Sort method cannot be used when a control is active, so the following code fails in a button click event procedure (because the control is still active after the user clicks it). Some Microsoft Excel Visual Basic methods and properties are disabled when an ActiveX control is activated. The following example scrolls the workbook window so CommandButton1 is in the upper-left corner. These properties can be set and returned using the ActiveX control name. In addition to the standard properties available for ActiveX controls, the following properties can be used with ActiveX controls in Microsoft Excel: BottomRightCell, LinkedCell, ListFillRange, Placement, PrintObject, TopLeftCell, and ZOrder. Keep the following points in mind when you are working with controls on sheets: For general information on adding and working with controls, see Using ActiveX Controls on a Document and Creating a Custom Dialog Box. This topic covers specific information about using ActiveX controls on worksheets and chart sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |