Setting ActiveX Control Properties
Every ActiveX control has properties, or settings, that determine its appearance and function. You can open a property sheet that displays all the settings for that control in alphabetic or category order directly from Excel. The ActiveX controls appear in the Properties window in two columns: the left column displays the name of the control, and the right column displays the current value or setting for the control. When you select either column, a list arrow appears in the right column, allowing you to select the setting you want. After you set properties, you can add VBA code to a module to make it perform.
Set ActiveX Control Properties
Click the Developer tab.
Click the Design Mode button (highlighted). ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
