You can write event procedures that run when the events occur. For example, a command button has a Click event that occurs when the user clicks the command button. You can initialize controls in a procedure.Īll controls have a predefined set of events. Right-click a control in design mode and click Properties to display the Properties window. For more specific information about using ActiveX controls in Microsoft Excel, see Using ActiveX Controls on Sheets.ĭisplay the Control Toolbox, click the control you want to add, and then click the document. Use the following procedure to add ActiveX controls to your document. Just as you can add ActiveX controls to custom dialog boxes, you can add controls directly to a document when you want to provide a sophisticated way for the user to interact directly with your macro without the distraction of dialog boxes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |